Match 2 criteria and index

[leonardtan]

Hi Excel Experts,

I trying other formulas to match the dates and time with vlookup and match but could not get the correct return value.

 

[John Jairo V]

Hi, @leonardtan!

You must add exact match in your VLOOKUP:

=IFERROR(VLOOKUP(C3,Data!B$2:O$19,MATCH(B3,Data!B$2:O$2,0),0),0)

or

=IFERROR(VLOOKUP(C3,Data!B$2:O$19,MATCH(B3,Data!B$2:O$2,),),)

Blessings!

 

[leonardtan]

Thank you