MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Function that returns a reference based on a Vlookup search


Posted by Guy Hoyle-Dodson on June 21, 2001 1:13 PM

I'd like to find a method of returning a cell reference from a vlookup function search of an array used in a formula. I'd like that cell reference to be the initial reference for an Offset function. Is there something simple out there or do I have to write and call a macro?


Posted by Mark W. on June 21, 2001 1:23 PM

VLOOKUP() and HLOOKUP() don't return a reference,
but INDEX() does. You can use INDEX() in combination
with MATCH() to behave like a VLOOKUP(). If you
don't know how to proceed from here provide some
"play" data and we'll construct a formula for you.