ian_noobster
New Member
- Joined
- Mar 19, 2018
- Messages
- 4
Hi,
I'm trying make have a sheet with drop down boxes which relate to the first 3 columns of the values below and basically make a singular formula that will look at the information from the drop down boxes and give me the code.
I think its something along the lines of
If Drop down 1 = product 1 & Drop down 2 = Blue & Drop down 3 = 10 the result will be Example code 1
Is there way of doing this?
<colgroup><col><col span="2"><col></colgroup><tbody>
</tbody>
Sorry i haven't explained this very clearly
Cheers
I'm trying make have a sheet with drop down boxes which relate to the first 3 columns of the values below and basically make a singular formula that will look at the information from the drop down boxes and give me the code.
I think its something along the lines of
If Drop down 1 = product 1 & Drop down 2 = Blue & Drop down 3 = 10 the result will be Example code 1
Is there way of doing this?
Product | Colour | Size | Code |
Product 1 | Blue | 10 | Example Code 1 |
Product 2 | Green | 5 | Example Code 2 |
<colgroup><col><col span="2"><col></colgroup><tbody>
</tbody>
Sorry i haven't explained this very clearly
Cheers