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!