Backboards: 
Posts: 157
In response to "aha. IF(ISERROR(MATCH(A3,[list],0)),"YES","NO") silly me. -- nm" by amanda

I [heart] iserror to fix problems with vlookup.

It makes the formula really long and incomprehensible but it works like a charm.

Responses:
Post a message   top
Replies are disabled on threads older than 7 days.