I have a 7 sheet spreadsheet.
Sheet 1 is where the formula will be going and it contains a dropdown menu with a list of product names and a dropdown menu with a list of product types. These names and types correspond to different name and types on sheets 2-6
On sheets 2-6 there is information (eg. name, percentage, code) that needs to go on sheet 1.
Sheet 7 is the information for the dropdown lists.
I need to work out how to achieve the following:
If, Product Name = ABC and Product Type = XYZ, the relevant information with regards to the Product Name and Type from sheets 2-6 automatically populates to Sheet 1.
Hope this makes sense.
Cheers
Sheet 1 is where the formula will be going and it contains a dropdown menu with a list of product names and a dropdown menu with a list of product types. These names and types correspond to different name and types on sheets 2-6
On sheets 2-6 there is information (eg. name, percentage, code) that needs to go on sheet 1.
Sheet 7 is the information for the dropdown lists.
I need to work out how to achieve the following:
If, Product Name = ABC and Product Type = XYZ, the relevant information with regards to the Product Name and Type from sheets 2-6 automatically populates to Sheet 1.
Hope this makes sense.
Cheers