Return value of lowest row (offset a few columns) between 2 cells after VLookup
Hello, I have decent excel experience, but this eludes me. Example: I have one big Excel file using only columns A-D (Roughly 10,000 rows) that contains employee ID#’s and their PTO balance/bank info below their name. Each month, we insert a row below the latest entry for that person to enter their new PTO balance information. Also, once every year that balance gets reset, and we place a full blank line between their current and previous lines to mark it.
Can I get assistance with a VLookUp formula that will search for their ID# within that document, then return the latest (lowest) value in column D for that person? Their information gains a row every month, and some have been here longer than others, so it would likely have to 1. Find their ID# 2. Find next persons ID# below them (All ID’s are setup as ID####) 3. Limit search to the rows between those two names 4. Return lowest non-blank cell in Column D.
Table Example:
The Vlookup should return the values that I have marked in blue (They are not formatted or colored on the actual document).
Any and all help is much appreciated! I’ve spent over 60 hours attempting this and still can’t get it working.
-Spike
Hello, I have decent excel experience, but this eludes me. Example: I have one big Excel file using only columns A-D (Roughly 10,000 rows) that contains employee ID#’s and their PTO balance/bank info below their name. Each month, we insert a row below the latest entry for that person to enter their new PTO balance information. Also, once every year that balance gets reset, and we place a full blank line between their current and previous lines to mark it. Can I get assistance with a VLookUp formula that will search for their ID# within that document, then return the latest (lowest) value in column D for that person? Their information gains a row every month, and some have been here longer than others, so it would likely have to 1. Find their ID# 2. Find next persons ID# below them (All ID’s are setup as ID####) 3. Limit search to the rows between those two names 4. Return lowest non-blank cell in Column D. Table Example: The Vlookup should return the values that I have marked in blue (They are not formatted or colored on the actual document). Any and all help is much appreciated! I’ve spent over 60 hours attempting this and still can’t get it working. -Spike Read More
