By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,426 Members | 3,338 Online
Bytes IT Community
+ Ask a Question
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
Share this Question
Share on Google+
4 Replies


P: n/a
On Jun 11, 12:47 pm, "mike14" <mik...@abc.comwrote:
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
VLOOKUP

Jun 11 '07 #2

P: n/a

"DavidB" <je***@yahoo.comwrote in message
news:11*********************@q75g2000hsh.googlegro ups.com...
On Jun 11, 12:47 pm, "mike14" <mik...@abc.comwrote:
>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

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" <mik...@abc.comwrote:
"DavidB" <j...@yahoo.comwrote in message

news:11*********************@q75g2000hsh.googlegro ups.com...


On Jun 11, 12:47 pm, "mike14" <mik...@abc.comwrote:
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
VLOOKUP

Thanks - I have *very* basic knowledge of VLOOKUP - could you give me an
idea 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!

Jun 11 '07 #4

P: n/a

"DavidB" <je***@yahoo.comwrote in message
news:11**********************@p47g2000hsd.googlegr oups.com...
On Jun 11, 2:27 pm, "mike14" <mik...@abc.comwrote:
>"DavidB" <j...@yahoo.comwrote in message

news:11*********************@q75g2000hsh.googlegr oups.com...


On Jun 11, 12:47 pm, "mike14" <mik...@abc.comwrote:
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
VLOOKUP

Thanks - I have *very* basic knowledge of VLOOKUP - could you give me an
idea 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.