G
Guest
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
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