Hi siddiqsh and welcome to the forum,
John's answer is perfect but you can also use a match function in a VLookup formula like
=VLOOKUP(B2,DATA!$C$2:$P$18,MATCH(RESULT!$C$1,DATA!$D$1:$P$1,0))
See both formulas in the attached.
Hi siddiqsh and welcome to the forum,
John's answer is perfect but you can also use a match function in a VLookup formula like
=VLOOKUP(B2,DATA!$C$2:$P$18,MATCH(RESULT!$C$1,DATA!$D$1:$P$1,0))
See both formulas in the attached.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks