Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup, then offset?
Hi, I have a spreadsheet that isn't really laid out well, but is too big to
change, so I'm hoping you can help me! I want to lookup a value in colum A, then use that cell address to lookup another value. ie, if the first lookup value is in A5, I want the data in D7. The data wanted will always be in column D, and always be 2 rows down from the value in column A. I hope that makes sense! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup, then offset?
It's ok, I've got it.
Offset and Match. Awesome. "SteW" wrote: Hi, I have a spreadsheet that isn't really laid out well, but is too big to change, so I'm hoping you can help me! I want to lookup a value in colum A, then use that cell address to lookup another value. ie, if the first lookup value is in A5, I want the data in D7. The data wanted will always be in column D, and always be 2 rows down from the value in column A. I hope that makes sense! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup with offset | Excel Worksheet Functions | |||
Lookup and offset | Excel Discussion (Misc queries) | |||
Lookup and offset | Excel Discussion (Misc queries) | |||
Help with Offset/Lookup | Excel Worksheet Functions | |||
lookup with offset? | Excel Worksheet Functions |