How do I find the cell reference for a vlookup?

G

Guest

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?
 
D

daddylonglegs

If your lookup range is A1:A10 and you want to return the correspondin
value (but one below) from B1:b10

=INDEX(B1:B10,MATCH(XYZ,A1:A10,0)+1
 
E

Excelenator

Assuming your columns are A & B and Rows are 1 and 2

=INDIRECT("B"&MATCH("XYZ",A1:A2,1)+1)



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?
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell Reference for table_array in Vlookup 1
How do I put cell data in between another cells data 4
calculate percentage of pay based on days old 2
Array Formulas 9
Excel 2013: AutoFilter and SUM() 1
Excel 2013 1
Sounds simple but isn't - displaying cell text 6
Help Using Countif 3

Top