Here is my problem;

Trying to match a six digit badge number (may or may not be on the
list it is matching to) to a table that contains a list of specific
badge numbers.

If that particular badge number matches on the list data I want it to
return a match. However, if it matches I need to add another criteria
to the formula. In the list that contains the specific badge numbers
is a date column. I want it to return "Yes" if that badge matches and
is <= to a certain time frame. If it doesn't fall within that date
range I want it to return "No".

Not sure which route to take, Vlookup, indexmatch, &if.........

Any help is much appreciated!!

Regards,

Peter