| 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 | |||
Linear Mode
