A
Alec H
Hi,
I am trying (unsuccessfully) to create a lookup sheet in a workbook.
The data that the user will lookup is stored on 2 sheets within the
workbook. They are;
1 - A Customer List that simply lists Company Name, Address, contact
details etc.
2 - An enquiry List that lists any enquiries recieved from customers.
There is a common field in the 2 lists of a unique customer number.
I have encountered 2 problems that are confusing me at the moment.
Problem 1 - How do I create a dropdown list on my new lookup sheet that
shows The Company name (the way that a user will search) on a different
sheet to the data? If I try and use Validation/List it tells me that
the list has to be on the same sheet as the lookup cell.
Problem 2 - Once the correct customer has been selected how do I get a
list of all enquiries (there may be several) relating to them to appear
on the lookup sheet. I have been dabbling with vlookup but without much
success...
I am trying (unsuccessfully) to create a lookup sheet in a workbook.
The data that the user will lookup is stored on 2 sheets within the
workbook. They are;
1 - A Customer List that simply lists Company Name, Address, contact
details etc.
2 - An enquiry List that lists any enquiries recieved from customers.
There is a common field in the 2 lists of a unique customer number.
I have encountered 2 problems that are confusing me at the moment.
Problem 1 - How do I create a dropdown list on my new lookup sheet that
shows The Company name (the way that a user will search) on a different
sheet to the data? If I try and use Validation/List it tells me that
the list has to be on the same sheet as the lookup cell.
Problem 2 - Once the correct customer has been selected how do I get a
list of all enquiries (there may be several) relating to them to appear
on the lookup sheet. I have been dabbling with vlookup but without much
success...