Hi All, I currently have a excel SS with 3 sheets. Column A on all 3 sheets is a list of account numbers I am using the Vlookup function to add the values of column B on sheets 2 and 3 to their correct account numbers on sheet one. I use this formula multiple times a year.

=VLOOKUP(A2,Sheet2!A1:B2423,2,FALSE)    Working

This formula currently works like a charm. This time around I have added sheet three and adjusted the

formula for the sheet and table array range and I am getting a value not available error #N/A.

=VLOOKUP(A2,Sheet3!A1:B2049,2,FALSE)     Not working

The whole spreadsheet is General for cell format, 2 to be okay for Col index as the values i want to pull are from column B and am pretty sure there are no random spaces I am missing. All of this is more confusing because the formula works for one sheet but not the other. Any assistance would be great. Thank you.

​Hi All, I currently have a excel SS with 3 sheets. Column A on all 3 sheets is a list of account numbers I am using the Vlookup function to add the values of column B on sheets 2 and 3 to their correct account numbers on sheet one. I use this formula multiple times a year.=VLOOKUP(A2,Sheet2!A1:B2423,2,FALSE)    WorkingThis formula currently works like a charm. This time around I have added sheet three and adjusted theformula for the sheet and table array range and I am getting a value not available error #N/A.=VLOOKUP(A2,Sheet3!A1:B2049,2,FALSE)     Not working The whole spreadsheet is General for cell format, 2 to be okay for Col index as the values i want to pull are from column B and am pretty sure there are no random spaces I am missing. All of this is more confusing because the formula works for one sheet but not the other. Any assistance would be great. Thank you.  Read More

​