Problem with VLOOKUP formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BigH - 14 Dec 2005 19:57 GMT

Hi there,

Hopefully someone can help, The problem I have is that I want the formula
below to lookup one sheet and if the answer is there great, if not then
lookup the other sheet as the answer must be on this sheet, however the
formula below doesnt do it. Any help would be appreciated.

=IF(ISNA(VLOOKUP(I3,'1103 NonAdhD This
Week'!$E$37:$F$1500,2,FALSE)),"",(VLOOKUP(I3,'1103 NonAdhD Last
Week'!$E$37:$F$1500,2,FALSE)))

regards BigH

Reply to this Message

Niek Otten - 14 Dec 2005 20:04 GMT

Surely you mean, simplified:

IF(ISNA(LookupThisWeek),LookupLastWeek,LookupThisWeek)

Signature

Kind regards,

Niek Otten

> Hi there,
>
[quoted text clipped - 8 lines]
>
> regards BigH

Reply to this Message

BigH - 14 Dec 2005 20:36 GMT

thanks Niek

> Surely you mean, simplified:
>
[quoted text clipped - 12 lines]
>>
>> regards BigH

Reply to this Message