software

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)),quot;quot;,(VLOOKUP(I3,'1103 NonAdhD Last
Week'!$E$37:$F$1500,2,FALSE)))

regards BigH
Surely you mean, simplified:

IF(ISNA(LookupThisWeek),LookupLastWeek,LookupThisW eek)

--
Kind regards,

Niek Otten

quot;BigHquot; gt; wrote in message
...
gt; Hi there,
gt;
gt; Hopefully someone can help, The problem I have is that I want the formula
gt; below to lookup one sheet and if the answer is there great, if not then
gt; lookup the other sheet as the answer must be on this sheet, however the
gt; formula below doesnt do it. Any help would be appreciated.
gt;
gt;
gt;
gt; =IF(ISNA(VLOOKUP(I3,'1103 NonAdhD This
gt; Week'!$E$37:$F$1500,2,FALSE)),quot;quot;,(VLOOKUP(I3,'1103 NonAdhD Last
gt; Week'!$E$37:$F$1500,2,FALSE)))
gt;
gt; regards BigH
gt;
thanks Niek
quot;Niek Ottenquot; gt; wrote in message
...
gt; Surely you mean, simplified:
gt;
gt; IF(ISNA(LookupThisWeek),LookupLastWeek,LookupThisW eek)
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;BigHquot; gt; wrote in message
gt; ...
gt;gt; Hi there,
gt;gt;
gt;gt; Hopefully someone can help, The problem I have is that I want the formula
gt;gt; below to lookup one sheet and if the answer is there great, if not then
gt;gt; lookup the other sheet as the answer must be on this sheet, however the
gt;gt; formula below doesnt do it. Any help would be appreciated.
gt;gt;
gt;gt;
gt;gt;
gt;gt; =IF(ISNA(VLOOKUP(I3,'1103 NonAdhD This
gt;gt; Week'!$E$37:$F$1500,2,FALSE)),quot;quot;,(VLOOKUP(I3,'1103 NonAdhD Last
gt;gt; Week'!$E$37:$F$1500,2,FALSE)))
gt;gt;
gt;gt; regards BigH
gt;gt;
gt;
gt;