If Statement with Vlook-Up using multiple criteria

I am going to provide a very simple example to my problem in the provided attachment- but in reality I am working with much more data.

Column A has the formula I am working with:
=IF(B2=$P$2:$P$5,VLOOKUP(B2,$P$2:$Q$5,2,FALSE))

I need to look up one cell in multiple rows of data- I thought I created a good formula (not sure) but all that keeps coming back is FALSE.

Can anyone please help me?

It will make more sense if you look at the attachment

Thank you so much in advance!

Hi

Using your example file what is wrong with just a straight vlookup?

Please Login or Register  to view this content.

rylo

Thanks SO much Søren Larsen- this works perfectly!!