In Cell B5 Paste below code :
=INDEX(Sheet2!$B$5:$D$10,MATCH(Sheet1!$C$2,Sheet2! $B$5:$B$10,0),2)
In Cell C5 Paste below code:
=INDEX(Sheet2!$B$5:$D$10,MATCH(Sheet1!$C$2,Sheet2! $B$5:$B$10,0),3)
In Cell B5 Paste below code :
=INDEX(Sheet2!$B$5:$D$10,MATCH(Sheet1!$C$2,Sheet2! $B$5:$B$10,0),2)
In Cell C5 Paste below code:
=INDEX(Sheet2!$B$5:$D$10,MATCH(Sheet1!$C$2,Sheet2! $B$5:$B$10,0),3)
Posting Permissions
Reply With Quote
Bookmarks