ExcelBanter - Vlookup not working for me.

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

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

- - Vlookup not working for me. (https://www.excelbanter.com/excel-worksheet-functions/141993-vlookup-not-working-me.html)

Vlookup not working for me.

Hi, I have a very simple workbook with 2 worksheets. I have Customers, which
contains a customer ID # and the customer name. Then I have the main
worksheet. I want to put in the customer ID # and have the Customer name pop
in. I have used this formula and it gives me a #NA
MAIN WORKSHEET
A
2 Customer ID Customer Name
3 1109 =VLOOKUP(A3,Customers!$A$2:$B$92,2,FALSE)

Customers Worksheet
Customer ID Customer
000 SPI WAREHOUSE

Vlookup not working for me.

Maybe your customer ID column is format as text then you must format cell A3
as text.

"Tbram" wrote:

Hi, I have a very simple workbook with 2 worksheets. I have Customers, which
contains a customer ID # and the customer name. Then I have the main
worksheet. I want to put in the customer ID # and have the Customer name pop
in. I have used this formula and it gives me a #NA
MAIN WORKSHEET
A
2 Customer ID Customer Name
3 1109 =VLOOKUP(A3,Customers!$A$2:$B$92,2,FALSE)

Customers Worksheet
Customer ID Customer
000 SPI WAREHOUSE