Vlook up display as NA

[Chris1973]

Hi There

I am using VLOOK UP to compare numbers and replace ols numbers. All Formats are in "GENERAL" and i have done a data validation as well. However does some of the numbers return as a NA

Formula i am using is as follow
=VLOOKUP(B15768;'Nuwe Rekening Nommers'!A15768:B58766;2;FALSE)

I have changed the format to Text, to Custom, To Number but still receive the same NA

Any advise what i am doing wrong, i have 43000 numbers to compare, and 39000 is right the others just don't want to pull thru

Thanks

View attachment 58480

 

[Chris1973]

@Joe4, thank you very much, the solution was the $ sign. All else was 100% the moment i redid the formula with the $ did everything display

 

[Joe4]

@Joe4, thank you very much, the solution was the $ sign. All else was 100% the moment i redid the formula with the $ did everything display

You are welcome!

Yes, whenever you put a "$" in front of a row or column reference in a formula, it "locks" that reference down, so that reference doesn't move as you copy the formula to other areas of your workbook.
Another method that some people use is to use Named Ranges instead. then you don't need to worry about that range changing on you.