Sorry for not providing more details.
I want to do a mass find/replace from an established list because there are too many Oz values. The conversion list will be like this:
0.1 Oz --> 2.95 ml
0.2 Oz --> 5.91 ml
0.3 Oz --> 8.87 ml
30 Oz --> 887 ml
i want run something that will scan this conversion list, get the correct value and replace it in the spreadsheet.
For example :
This bottle is 0.2 Oz and is great.
The function will look into the table, get the corresponding value for 0,2 Oz (5.91 ml) and the output will be:
This bottle is 5.91 ml and is great.