is there a way to get address_of(vlookup(.....)) ??
where address_of = "A25" (or something in that format) ??
views:
43answers:
1
+1
A:
Use Match rather than Lookup. The formula below assumes you've got a lookup table in A1:A12.
It looks for the value "60" and turns the returned row index into a textual range address (e.g. "$A$6").
=ADDRESS(MATCH(60,A1:A12),1)
Marc Thibault
2010-09-17 22:30:23