| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Want VLookup to Return the row above
I have the VLOOKUP function:
=VLOOKUP(G1360,D4:G1358,COLUMNS(D1:G1)) which is properly returning the value in row G which corresponds to the value in G1360. How do I get it to return the value in the row above the row which has the value in G1360? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup of an if statement return | Excel Worksheet Functions | |||
| Vlookup - return row no. instead of value | Excel Discussion (Misc queries) | |||
| Can VLOOKUP return multiple answers based on several identical lo. | Excel Worksheet Functions | |||
| VLookup Return Value | Excel Worksheet Functions | |||
| Can vlookup return multiple matches in a single cell? | Excel Discussion (Misc queries) | |||
Threaded Mode
