View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Curious Excel User Curious Excel User is offline
external usenet poster
 
Posts: 2
Default 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?