Thread: Giving me a error ( =REF! )
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steved Steved is offline
external usenet poster
  
Posts: 519
Default 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))
Reply With QuoteReply With Quote