| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Giving me a error ( =REF! )
=IF(ISNA(VLOOKUP(A122+0,'Go Wellington'!$A$2:$F$1968,6,FALSE)),0,VLOOKUP(A122+ 0,'Go Wellington'!$A$2:$F$1968,6,FALSE)) =IF(ISNA(VLOOKUP(A122+0,'Go Wellington'!$A$2:$F$1968,7,FALSE)),0,VLOOKUP(A122+ 0,'Go Wellington'!$A$2:$F$1968,7,FALSE)) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Giving me a error ( =REF! )
Hello from Steve Dee
"Steved" wrote: Hello from Steved From this =IF(ISNA(VLOOKUP(A122+0,'Go Wellington'!$A$2:$F$1968,6,FALSE)),0,VLOOKUP(A122+ 0,'Go Wellington'!$A$2:$F$1968,6,FALSE)) To this giving me =REF! Is their another formula that I can use please to resolve my Issue. Thankyou. =IF(ISNA(VLOOKUP(A122+0,'Go Wellington'!$A$2:$F$1968,7,FALSE)),0,VLOOKUP(A122+ 0,'Go Wellington'!$A$2:$F$1968,7,FALSE)) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Giving me a error ( #REF! )
Hello from Steved
I meant #REF! "Steved" wrote: Hello from Steve Dee "Steved" wrote: Hello from Steved From this =IF(ISNA(VLOOKUP(A122+0,'Go Wellington'!$A$2:$F$1968,6,FALSE)),0,VLOOKUP(A122+ 0,'Go Wellington'!$A$2:$F$1968,6,FALSE)) To this giving me =REF! Is their another formula that I can use please to resolve my Issue. Thankyou. =IF(ISNA(VLOOKUP(A122+0,'Go Wellington'!$A$2:$F$1968,7,FALSE)),0,VLOOKUP(A122+ 0,'Go Wellington'!$A$2:$F$1968,7,FALSE)) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using NAMES in SUMPRODUCT giving error | Excel Worksheet Functions | |||
| Function giving error | Excel Discussion (Misc queries) | |||
| Function giving Error | Excel Worksheet Functions | |||
| LOOKUP funciion giving an error | Excel Worksheet Functions | |||
| Excel help giving runtime error | Excel Discussion (Misc queries) | |||
Hybrid Mode
