Vlookup returning #N/A

Hi all,

I'm using excel 2007 (but this shouldn't be an issue), I have created an unique ID for each of my Customers on "Customers table".

I want to look at the table and place in another table all the most important info on each customer e.g.

customer id Address Last Order Price

The sells info is on the sales table, so I want to lookup customer id on first table and get the sell data from the second table.

I tried =VLOOKUP(A1,'customer table!'A1:C45,5,False)

A1 is the customer id and 5 is the column number which could return the address, but all I'm getting is the return #N/A.

Your range has 3 columns (Col A to C) and your criteria is set to return col 5.

VBA Noob

Change the 5 to 1 as the table only has one col.

e.g Col is C = 1 col in table


=VLOOKUP('customer table!'A1,'Sales!'C$2:C$329,1,false)

VBA Noob

You need to match the lookup cell value with the first column

The example below looks at D2 on Sheet Customer Table (J-B-7YG) and then looks at sales sheets Col A to C.

I entered 3 as the col to return the value. By entering 1 it will return J-B-7YG and 2 will return the address line - 1, the road

=VLOOKUP('customer table'!D2,sales!A:C,3,FALSE)

Hope that helps. Link shows you more

http://www.contextures.com/xlFunctions02.html


VBA Noob