TWOWAY VLOOKUP - matching date in row and name in column

[Nadimtukin]

HI

I again need help with multiple vlookup.

I have date in rows and list of supplier in column A, I want to vlookup date and supplier name both and put value. see attached sheet.

Thanks

Nadim

[AliGW]

In B17 copied down:

=INDEX($B$2:$G$6,MATCH(A17,$A$2:$A$6,0),MATCH(B$16,$B$1:$G$1,0))

[JohnTopley]

In B17

=INDEX($B$2:$G$6,MATCH($A17,$A$2:$A$6,0),MATCH($B$16,$B$1:$G$1,0))

copy down

[Nadimtukin]

Thanks you so much ALi and John Both..