VLookup twice in same formula

Hi Doug

Thanks for the reply.

Yes, it works.

The Text function is used as I am looking up a number in a text field. If I don't change my number to text, then the formula fails.

The function extracting a date. In the lookup sheet this is either a date or the word "NULL" (not an empty field). So if it is Null, I set the returned value to 1 (1/1/1900), if it's not null then I use the value that vlookup finds.

So, I look up the date, set it as 1 if the date is "NULL", if not then I lookup the date again to find the value.

I guess I could add a macro to delete all "NULL" fields - or even change them to 1, but I don't want any manual steps, just add the data and get the results.

I can't see an easier way to do it (except with VBA), but wondered if any of you guys knew of some trick to make the repeated vlookup not necessary.

It's no big deal as it works anyway, I was just wondered if there was a more efficient way to do it.

Regards

Richard