=IFERROR(INDEX('Lev1'!$B$8:$N$13,MATCH($A2,'Lev1'!$B$8:$B$13,0),MATCH($B$1,'Lev1'!$B$8:$N$8,0)),"NA")
Try the above in "B2" Cell of Results sheet and copy towards down
=IFERROR(INDEX('Lev1'!$B$8:$N$13,MATCH($A2,'Lev1'!$B$8:$B$13,0),MATCH($B$1,'Lev1'!$B$8:$N$8,0)),"NA")
Try the above in "B2" Cell of Results sheet and copy towards down
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks