MrExcel Publishing
Your One Stop for Excel Tips & Solutions


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?


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


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

Thanks, Ian ... That will do it !