Spreadsheet: 142158d1329696850-nested-ifs-converter
Sheet: Sheet1

Column a, rows 5 through 22 is a list named unit list one. It supplies the drop downs in column E, rows 8 through 16. Everything in the spreadsheet from row 1 through 22 works as intended. Column K Was originally created to differentiate unit types so that an error could be detected and an error message (mismatched unit types) could be displayed. It may or may not be used in the final version.  The marroon cells are for the input of data. F7 allows the user to scale the recipe  in B7-E16 up or down and be displayed in H7-J16. |  |  |  |  |  |  |  |  |  |  | From B18 - j40, all of the ingredients in the scaled recipe from [NAME], are present in table form converted to all unitit types which are appropriate, volume to volume, weight to weight.  Originally, I was going to have drop down lists in each column where the user could choose the units for each ingreadient he/she wanted to convert. The table has the advantage of converting to all units at once. The drop down idea, has the advantage of being more compact (semi important) and reducing user error be misreading the outputed data in that table.
cc
[NAME]. | Original Formulation |  |  |  | Adjusted to | New Formulation
cu. in. | Component | Name | Qty. | Unit | 0.5 |  |  |  |  | Type
cu. yds. | A | [NAME] | 5 | lbs. (US) |  | A
cups (US) | B | Choc chips | 32 | oz. (wt.) |  | B
fl. oz. (US liquid) | C | sugar | 2.5 | lbs. (US) |  | C
gals. (US liquid) | D | brn sugar | 2.5 | lbs. (US) |  | D
grains | E | vanilla | 3 | tsp. (US) |  | E
grams | F | eggs | 6 | fl. oz. (US liquid) |  | F
kgs. | G | Raw Tuna | 0 | tons (US) |  | G
lbs. (US) | H | Nothing | 0 | cc |  | H |  |  |  |  | I would prefer the converted data in the table, to be in the form of 9 drop down lists (for components A through I ).  The units would be chosen in row 24 column B through J, while the values would display in row 23, coumns B through J.
litres | I | Nothing | 0 | cc |  | I
oz. (wt.)
pints (US liquid) | New formula to Various Units of Measurement
quarts (US liquid) | A | B | C | D | E | F | G | H | I
[NAME]. (US)
tons (US) | Converted | Converted | Converted | Converted | Converted | Converted | Converted | Converted | Converted
tsp. (US) | to | to | to | to | to | to | to | to | to |  | Finally, the unitlist1 (A5 to A22) is only displayed here to make it easy to see while developing the spreadsheet. Final version this should not be visible. Similarly, if a drop down can be worked out instead of a table in the unit conversion area, then the list of items in A23 to A40, is likewise unnecessary, and unwanted.    Now that you can see what the whole spreadsheet should do and look like, what would be the best approach?
cc |  |  |  |  |  |  |  |  |  | volume
[NAME]. |  |  |  |  |  |  |  |  |  | volume
cu. in. |  |  |  |  |  |  |  |  |  | volume
cu. yds. |  |  |  |  |  |  |  |  |  | volume
cups |  |  |  |  |  |  |  |  |  | volume
fl. oz. |  |  |  |  |  |  |  |  |  | volume
gals. |  |  |  |  |  |  |  |  |  | volume
grains |  |  |  |  |  |  |  |  |  | weight
grams |  |  |  |  |  |  |  |  |  | weight
kgs. |  |  |  |  |  |  |  |  |  | weight | I am especially interested, in the method (if any) that would minimize the amount of typing to finish this up - especially redundane typing. Remember I know nothing of lookups etc, but if that is something I should learn, then I want to learn it.
lbs. |  |  |  |  |  |  |  |  |  | weight
litres |  |  |  |  |  |  |  |  |  | volume
oz. (wt.) |  |  |  |  |  |  |  |  |  | weight
pints |  |  |  |  |  |  |  |  |  | volume
quarts |  |  |  |  |  |  |  |  |  | volume | Thanks again for your generous help.
[NAME]. |  |  |  |  |  |  |  |  |  | volume
tons |  |  |  |  |  |  |  |  |  | weight
tsp. |  |  |  |  |  |  |  |  |  | volume