Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with VLOOKUP formula
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with VLOOKUP formula
Surely you mean, simplified:
IF(ISNA(LookupThisWeek),LookupLastWeek,LookupThisW eek) -- Kind regards, Niek Otten "BigH" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with VLOOKUP formula
thanks Niek
"Niek Otten" wrote in message ... Surely you mean, simplified: IF(ISNA(LookupThisWeek),LookupLastWeek,LookupThisW eek) -- Kind regards, Niek Otten "BigH" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula problem | New Users to Excel | |||
Updating formula with link to another worksheet using vlookup | Links and Linking in Excel | |||
Vlookup, What is correct formula for problem below? | Excel Worksheet Functions | |||
Vlookup Problem | Excel Worksheet Functions | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions |