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

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