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