Yeah that's a simple 2D lookup.
Try this in B11:
![]()
=INDEX(B3:E6, MATCH(B8, A3:A6, 0), MATCH(B10, B1:E1, 0))
Yeah that's a simple 2D lookup.
Try this in B11:
![]()
=INDEX(B3:E6, MATCH(B8, A3:A6, 0), MATCH(B10, B1:E1, 0))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks