Use,
=Index(Sheet1!$B$2:$L$7,match(B3,Sheet1!$B$1:$L$1,0),match(E3,Sheet1!$A$2:$A$7,0)
Use,
=Index(Sheet1!$B$2:$L$7,match(B3,Sheet1!$B$1:$L$1,0),match(E3,Sheet1!$A$2:$A$7,0)
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks