Hi Marvin,
if I select A in sheet Result!C1, it returns AAA in front of AAA whereas it should return 0.27
Quote Originally Posted by MarvinP View Post
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.