Thanks for the feedback

"alex genadeloos" wrote in message
oups.com:

JMay

Works like a charm!

Thx.

Alex

JMay wrote:
You could Expand your range to be $O$1:$P$202 and use:
=IF(VLOOKUP(A5;$O$1:$P$202;1)=A5; VLOOKUP(A5;$O$1:$P$202;2);"NOK")
HTH