returning the address of a value

E

Excel Enthusiastic

If a value is found using vlookup or hlookup, how do I return the address of
such value instead of the value itself?
 
G

Gary''s Student

say we have in F1 thru H14:

1 88 61
1 110 91
2 123 87
2 69 103
2 147 68
3 139 52
4 56 70
5 110 145
6 141 95
7 68 76
8 92 94
9 56 110
10 144 114
11 124 96


and in A1 we have 7 and in B1:
=VLOOKUP(A1,F1:H14,3)
we will see 76 the value in column H
in B2 put:
=MATCH(B1,H1:H14,0)
we see 10.

So H10 is the address containing the vlookup result
 
Top