VLOOKUP AND RETURN THE CELL REFERENCE

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

Thanks, Ian ... That will do it !