ExcelBanter - Giving me a error ( =REF! )

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Giving me a error ( =REF! ) (https://www.excelbanter.com/excel-worksheet-functions/244551-giving-me-error-%3Dref.html)

Steved

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

Steved

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

Steved

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

All times are GMT +1. The time now is 11:19 PM.