Im close but still not quite there. This is what I have so far.
=VLOOKUP(A2003&"*",Lists!B4:J68,1,FALSE)
I have sheet 1 that I enter a code and sheet 2 (Lists) that has all the corresponding codes to customer data. The problem is that I want to look through several column's in sheet 2 with codes in say column B, C, D, etc, with column A with customer data. Each customer has several codes in other words. So that when I enter a code in sheet 1, data is automatically filled in due to the code in sheet 1 matching to the code in sheet 2 and the customer data in column A.
For example, if I enter 1457-0034 in sheet 1, sheet 2 can pick up on the first part of the code (1457-) and place the customer data in a chosen cell in sheet 1. But the formula i have entered places the first customer name and does not recognised any codes I enter into sheet 1. What have I done wrong?
=VLOOKUP(A2003&"*",Lists!B4:J68,1,FALSE)
I have sheet 1 that I enter a code and sheet 2 (Lists) that has all the corresponding codes to customer data. The problem is that I want to look through several column's in sheet 2 with codes in say column B, C, D, etc, with column A with customer data. Each customer has several codes in other words. So that when I enter a code in sheet 1, data is automatically filled in due to the code in sheet 1 matching to the code in sheet 2 and the customer data in column A.
For example, if I enter 1457-0034 in sheet 1, sheet 2 can pick up on the first part of the code (1457-) and place the customer data in a chosen cell in sheet 1. But the formula i have entered places the first customer name and does not recognised any codes I enter into sheet 1. What have I done wrong?
