| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup cell 1 below another cell
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Nate" wrote in message ... Sorry. I wasn't familiar with the match formula at first. This is exactly what I was looking for. Thanks! "T. Valko" wrote: If your VLOOKUP formula was something like this: =VLOOKPU(A1,A2:B100,2,0) Then try something like this: =INDEX(B2:B100,MATCH(A1,A2:A100,0)+1) -- Biff Microsoft Excel MVP "Nate" wrote in message ... I'm trying to add a formula that will return the cell directly below the cell that my VLOOKUP formula pulled from. Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Get Cell Address From Lookup (Alternative to Lookup) | Excel Worksheet Functions | |||
| Show a blank result in a cell when there is no value in the "Lookup" cell | New Users to Excel | |||
| Need to lookup value in cell, dependent on value in another cell | Excel Worksheet Functions | |||
| formatting a cell the same as the source cell from a lookup table | Excel Discussion (Misc queries) | |||
| Lookup and Sum in same cell | Excel Discussion (Misc queries) | |||
Threaded Mode
