MrExcel Publishing
Your One Stop for Excel Tips & Solutions

VLOOKUP AND RETURN THE CELL REFERENCE


Posted by Ger Dineen on September 16, 2001 9:42 AM

I am trying to do a sort of vlookup that will return the cell reference for the matching value not the value itself ... can anyone help ?


Posted by Ian on September 16, 2001 10:19 AM

not sure entirely what you mean, but does this do what you want?

=ADDRESS(MATCH(E7,A1:A4,0),1,1)

where e7 is the value to lookup

this will return the the first column reference you can change the first ,1 to what ever you want 2 being column B

the second ,1 makes the reference absolute e.g $A$1
you can use numbers 1 - 4 to change between the diiferent types of reference 4 being A1 (without the $'s)

any help

Ian

Posted by Ger Dineen on September 16, 2001 10:28 AM

Thanks, Ian ... That will do it !