Get data 2 criteria

[stormania]

Dear Excel Master

Kindly your help, I have a problem to fill in number from different sheet, I try vlookup but can’t cause have 2 criteria at a header. In attach file, how to fill in yellow cell in recap sheet base on data stand sheet ?

Thank you

 

[stormania]

Sory, here attach file

How to fill in yellow cell ?

 

[bosco_yip]

1] If you have Excel2021 or Office 365, please see as per below image

In C2, formula copied across and down:

=VLOOKUP($A2,STAND!$A:$M,MATCH(C$1&"MFL",STAND!$1:$1&STAND!$2:$2,0),0)

2] If you have Excel2019 or below, try to use

In C2, formula copied across and down:

=VLOOKUP($A2,STAND!$A1:$M100,INDEX(MATCH(C$1&"MFL",STAND!$A$1:$M$1&STAND!$A$2:$M$2,0),0),0)

 

[stormania]

Thank you, its work, amazing