Index & Match with Concatenation

[rickyilas]

Hi,

I will pls. need a formula probably an Index & Match but I just couldn't figure it out how.

I need to look up values in Sheet Engineering for each personnel's hours monthly and this will be reflected in the Data Sheet.

The reference to look is the Badge# plus the year_month combined as a concatenation.

I've attached a spreadsheet to explain better what I need.

Appreciate your helps as always.

[NBVC]

If you can use columns B and I instead of column A, which looks like those 2 columns combined to give a code, then

=INDEX(Engineering!$U:$AM,MATCH(B2,Engineering!$C:$C,0),MATCH(I2,Engineering!$U$11:$Y$11,0))

copied down.

[rickyilas]

Thanks NBVC. Exactly what I needed.