|Look at the VLOOKUP function. I don't have Excel available right now, but it sounds like VLOOKUP wrapped in a IF(ISNA(...)) function should work.|
If you can't figure it out, let me know. I'll have Excel available in a couple of hours.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
message edited by DerbyDad03