IF with VLOOKUP?

[jeptik]

Hello,

In the attached file, I would like to return values for the corresponding month in column J as indicated for Jun & May.

I would like a formula created to do this as the spreadsheet is quite large.

Can someone assist me in creating a formula for this please?

Thanks.

[JohnTopley]

Try

=INDEX($B2:$I2,MATCH($A2,$B$1:$I$1,0))

copy down

[jeptik]

This works great! Thanks John!!