=INDEX(Sheet3!$D$3:$I$6,MATCH($A3,Sheet3!$A$3:$A$6,0),MATCH(Sheet2!D1,Sheet3!$D$1:$I$1,0))
=INDEX(Sheet3!$D$3:$I$6,MATCH($A3,Sheet3!$A$3:$A$6,0),MATCH(Sheet2!D1,Sheet3!$D$1:$I$1,0))
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks