You can try this also:
Paste below code in Cell B5 and drag it to Next cell (C5):
=INDEX(Sheet2!$B$5:$D$10,MATCH(Sheet1!$C$2,Sheet2! $B$5:$B$10,0),MATCH(B$4,Sheet2!$B$4:$D$4,0))
You can try this also:
Paste below code in Cell B5 and drag it to Next cell (C5):
=INDEX(Sheet2!$B$5:$D$10,MATCH(Sheet1!$C$2,Sheet2! $B$5:$B$10,0),MATCH(B$4,Sheet2!$B$4:$D$4,0))
Posting Permissions
Reply With Quote
Bookmarks