435,426 Members | 3,338 Online
Need help? Post your question and get tips & solutions from a community of 435,426 IT Pros & Developers. It's quick & easy.

# compile data from 2 worksheets or tables?

 P: n/a I have data currently stored in an excel worksheet - consists of a record of customer names with address details, all in seperate columns - in another worksheet I have a list of customer names (no addresses) and a record of bookings made by the customers, again in seperate columns - I need to compile a list of customers and addresses but only for those customers who have a current booking - any suggestions? Is it possible to do that in excel or does it need to be done in access - if access then how would I do it? TIA Jun 11 '07 #1
4 Replies

 P: n/a On Jun 11, 12:47 pm, "mike14"

 P: n/a "DavidB" I have data currently stored in an excel worksheet - consists of a recordofcustomer names with address details, all in seperate columns - in anotherworksheet I have a list of customer names (no addresses) and a record ofbookings made by the customers, again in seperate columns - I need tocompile a list of customers and addresses but only for those customerswhohave a current booking - any suggestions? Is it possible to do that inexcelor does it need to be done in access - if access then how would I do it?TIA VLOOKUP Thanks - I have *very* basic knowledge of VLOOKUP - could you give me an idea of the formula? Jun 11 '07 #3

 P: n/a On Jun 11, 2:27 pm, "mike14" "HELLO ". Hint, use TRIM() to clean up the data if needed. Use the other worksheet, bookings, as the lookup range. Put the customer name in column A and SORT ON THAT COLUMN! read trhe help file to understand how to deal with rows in the master worksheet that do not have a match in the look up sheet! Jun 11 '07 #4

 P: n/a "DavidB" "DavidB" TIA VLOOKUP Thanks - I have *very* basic knowledge of VLOOKUP - could you give me anidea of the formula?- Hide quoted text -- Show quoted text - The short answer is that it is described fully in the help built into excel. The more detail answer is that you look up a value in a range and return a second value on the matching data. use whichever of these two worksheets is your primary sheet as the value you are looking up. In other words put you VLOOKUP in that sheet. Look up on the value that you want to match against in the other worksheet, probably customer name/address sheet. Be aware that extraneous blank spaces will cause a non-match. So that "HELLO" <> "HELLO ". Hint, use TRIM() to clean up the data if needed. Use the other worksheet, bookings, as the lookup range. Put the customer name in column A and SORT ON THAT COLUMN! read trhe help file to understand how to deal with rows in the master worksheet that do not have a match in the look up sheet! thanks mike14 Jun 12 '07 #5

### This discussion thread is closed

Replies have been disabled for this discussion.