Check if an item exist in my shelf

[xlnab]

Hello guys!

I'm so sorry if this is basic but I searched everywhere online and in the forum. I can't find a way to do this and can't come up with the right question.
If this is a duplicate, i'm sorry, please point me in the right direction.

Considering the example bellow, I need a way to check if the items in the column ITEM exists in the shelf and if not, if they exist in the warehouse to warn me.
I tried MATCH, INDEX, LOOKUP, but I cant figure out to match the conditions i need.

Can someone help me please?
Thansk in advance.

Item

Date

Location

Item 1	2019	Shelf
Item 2	2019	Warehouse
Item 3	2019	Shelf

 

[VBE313]

Like this?

 

[xlnab]

Like this?
View attachment 22480

Oh my lord, I would never get there alone, that is amazing! Is it possible to make it like this? How can I make it?

 

[VBE313]

If you just want Ok next to Shelf and NOK next to warehouse then you can do this

=IF(C2="Shelf","OK","NOK")

 

[xlnab]

If you just want Ok next to Shelf and NOK next to warehouse then you can do this

=IF(C2="Shelf","OK","NOK")

I'm not expressing my self correctly, i'm sorry, this is too complex to me.
I feel you are very close to what I'm looking for. Can you look below please?

 

[xlnab]

Thank you for your help, I found a way. I concatenated the two cells ITEM and LOCATION and make a vlookup, does the trick! Thank you so much for enlighten me!!!