Thread
:
VLookup and HLookup at the same time
View Single Post
#
2
John Michl
Posts: n/a
You could use a combination of Match and Index. Assuming your table is
in the range A1:D4 (where A1 is blank and D4 = 9), the following will
work:
=INDEX(B2:D4,MATCH("A",A2:A4),MATCH("E",B1:D1))
- John
Reply With Quote