Vlookup across multiple sheets?

[Tintyn]

Hi guys,

I'm having trouble getting 2 formulas right the first one should be easy...

cust no | Customer
--------------+--- -----------
blank cell1 - Customer Name 1
blank cell2 - Customer Name 2


I have 2 sheets one has empty customer number fields next to 645 customer names (potential customer as well as existing), the second sheet contains filled in customer number fields next to a much smaller amount of customer names (existing customer). What i'm trying to do is populate the blank customer column with customer numbers from the second but only where the 2 customer names match perfectly. I'm sure vlookup is the one for this I just cant seem to get syntax right.

Secondly i've got a month by month budget itemized by customer in one sheet and I need the data exported into another xml sheet by my pos software at the end of month to be scraped and filled into the budget sheet.

Any help greatly appreciated!

Tintyn

 

[CharlesChuckieCharles]

Because VLOOKUP expects the First column to be the Key and cannot reference column -1

INDEX Match is the way to go


=INDEX(ListofExistingCust!$B$4:$C$11,MATCH(C4,ListofExistingCust!$C$4:$C$11,0),1)

C4
is the customer name on your long list sheet with cust no's


ListofExistingCust!$B$4:$C$11

CustNO CustomerName
12345 Big Cust
67895 Small Cust



ListofExistingCust!$C$4:$C$11

CustomerName
A Cust
B Cust
Big Cust
Good Cust
Small Cust