Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I find the cell reference for a vlookup?
I am trying to find the cell value of the cell one row below the vlookup
value. For example: Example1 is a range for the following information. XYZ Widget Widget Description VLOOKUP(XYZ,Example1,2,FALSE) returns Widget I want to find the Widget Description value. Any ideas? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I find the cell reference for a vlookup?
If your lookup range is A1:A10 and you want to return the corresponding value (but one below) from B1:b10 =INDEX(B1:B10,MATCH(XYZ,A1:A10,0)+1) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=567673 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I find the cell reference for a vlookup?
Assuming your columns are A & B and Rows are 1 and 2 =INDIRECT("B"&MATCH("XYZ",A1:A2,1)+1) Curious Excel User Wrote: I am trying to find the cell value of the cell one row below the vlookup value. For example: Example1 is a range for the following information. XYZ Widget Widget Description VLOOKUP(XYZ,Example1,2,FALSE) returns Widget I want to find the Widget Description value. Any ideas? -- Excelenator ------------------------------------------------------------------------ Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768 View this thread: http://www.excelforum.com/showthread...hreadid=567673 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
Convert VLOOKUP to absolute cell reference | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
how to create a variable column in cell reference | Excel Worksheet Functions |