multiple lookup

thanks, now it is perfect

Originally Posted by MarvinP

Sorry I was one off in my columns... Try this instead

=VLOOKUP(B2,DATA!$C$2:$P$18,1+MATCH(RESULT!$C$1,DATA!$D$1:$P$1,0))