Getting a cell refrence from vlookup

Oorang

Well-known Member
Joined
Mar 4, 2005
Messages
2,071
Is there a non-VBA way to return the cell address the vlookup found the value in, rather than the value itself?
 

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,402
MATCH will give you the offset within the range you are searching ... and from that you can work out which cell the value was found in.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,432
Messages
5,572,074
Members
412,437
Latest member
PietTheijssen
Top