Mar 15 2021 05:05 AM
Hi All,
Hope you can help.
I have a drop down menu which contains certain types of Timber (Lumber for my american friends). E.G 4x2, 5x2, 6x2. Based on what is selected I want the cell adjacent to display the timber width, so if i select 4x2 i want the cell adjacent to display 95.... Tried using an If function with no joy.
Any help would be much appreciated.
Mar 15 2021 05:24 AM
For whos who have no idea about Timber and Lumber could you please explain what is the logic behind this conversion, why 4x2 goes to 95, etc. Do you have some mapping for that or what?
Mar 15 2021 05:38 AM
Mar 15 2021 06:02 AM - edited Mar 15 2021 06:03 AM
@SBolster , thank you.
To multiply one on another
with
=LEFT(D3,FIND("x",D3)-1)*RIGHT(D3,LEN(D3)-FIND("x",D3))
After that I didn't catch. 4x2 gives 8 inches, not 4. And 8 inches is about 20 cm, not 95 cm. In general you may use CONVERT() function to wrap above selecting proper units.
Mar 15 2021 06:05 AM
Mar 15 2021 06:18 AM
Mar 15 2021 06:18 AM
It's nothing to do with the sizes that i'm trying to work out. All im trying to do is if i select the Timber Size 4x2 - then 92mm or whatever the "actual" size is in mm doesn't have to be accurate at this stage. I don't need it to work out the sizes e.t.c. I just want to select the timber being used for a specific Job. Then it'll output the width of that timber in the adjacent cell, i was trying the IF function but it wasn't working. Hope i'm making sense
Mar 15 2021 06:31 AM
It looks like you need to have mapping table of Timber Size - width, and XLOOKUP() the proper width from it.