Lookup

Hi There - can anyone help plse.

I am trying to look up a region & product name combination in a table and returning the status (live or discontinued).

Unfortunately in the lookup up table the product name can either be a number or a group of letters.

Is there a way of looking up the numeric product name and if not then trying the alphabetical name.

As always much appraciated.

Thanks

Tom