Giving me a error ( =REF! )

  • Thread starter Thread starter Steved
  • Start date Start date
S

Steved

=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))
 
Hello from Steve Dee

:
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))
 
Hello Barry

Thankyou very much ( I might need to go get some lessons ) as I should off
looked a little futher.

Steve
 
Back
Top