Index match question

[Philippe de Vlaminck]

Hey all,

I have been looking for an answer to following match/lookup question:
I have a column with recurring products and one with a status:

Product A Ok Lookup /match column
Product B NOk
Product C Ok
Product D Ok
Product E NOK
Product A Ok
Product C NOK
Product B OK
...


And I would like to look through the column for a specific product and return an ok to the lookup column if it exists in the lookup range.

For instance row 2 product B is NOK however on the bottom row it is. Therefor it should return an OK.

Anyone help would be much appreciated.
Been looking at index match and index small formulas but no luck figuring it out yet

Kind regards,
Phil

 

[Philippe de Vlaminck]

Thx Marcilio, works like a charm! Much appreciated

Kind regards,
Philippe