In my spreadsheet in cell A3. I have a number 001700.
In my next spreadsheet rates, the number is displayed as 1700.
When I use this forumla, excel doesn't recognize this as the same number.
I have tried changing the format so the numbers look the same, but still no
luck.
What am I doing wrong?

=IF(ISNA(VLOOKUP(A3,RATES'!$A$1:$B$172,2,FALSE)),0 ,VLOOKUP(A3,RATES'!$A$1:$B$172,2,FALSE))
--
Me