Giving me a error ( =REF! )

[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))

 

[Steved]

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))

 

[barry houdini]

Hello Steve,

The column index (7 in your second formula) is greater than the numbe
of columns in the lookup range, i.e. 'Go Wellington'!$A$2:$F$1968, henc
#REF!

if you want to return a value from column G then you need to extend th
range as well as adding 1 to the column index, i.e. formula would be

=IF(ISNA(VLOOKUP(A122+0,'G
Wellington'!$A$2:$G$1968,7,FALSE)),0,VLOOKUP(A122+0,'G
Wellington'!$A$2:$G$1968,7,FALSE))

Note: this is a good example of why ISNA is better than ISERROR
ISERROR would just mask the #REF! error.....

regards, barr

 

[Steved]

Hello from Steved

I meant #REF!

 

[Steved]

Hello Barry

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

Steve