Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup question
Hi All,
I asked this question previously but perhaps did not explain it too well, I will try again. I have two different spreadsheets, A & B in excel 2007 and am trying to compare like Customer ID Numbers between the two spreadsheets. Spreadsheet A is a weekly report of sales and has the following columns: Cust ID, Cust Name, Sales Order #, Date, Status, Sales Amount & Sales Rep. the length always changes from week to week, but the columns remain the same. Spreadsheet B is a running report of customers that our telemarketer has brought into our store. It has many columns, but one of which is the CustID, just like in the previous Spreadsheet A. I would like to run a formula, in Spreadsheet A that will take the Cust ID on each row in Spreadsheet A and compare it to the list of those Cust ID's in Spreadsheet B. If the Cust ID is not found, do nothing. If the Cust ID is found - I would then like to have the Sales Amount value brought in as the result. Column ID's in Spreadsheet A: 1st Column (A) is Cust ID 6th Column (F) is Sales Amount 9th Column (I) is where I would like this formula (and result if the Cust ID is on the other spreadsheet) to go. Column ID in Spreadsheet B: Cust ID is in column H and will either have a four digit numerical number representing the Customer ID Number, or it will be blank. I can reformat the number to be text if that will help in the lookup. Thanks for your help, if you have any questions, or if I can clarify the example better, please let me know. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup question | Excel Worksheet Functions | |||
VLOOKUP Question | Excel Worksheet Functions | |||
vlookup vba question. | Excel Discussion (Misc queries) | |||
If/And/Vlookup question | Excel Discussion (Misc queries) | |||
Question on Vlookup | Excel Worksheet Functions |