Hi all,

I'm in the process of making a unit conversion spreadsheet to calculate specific gravities of different chemicals, but am unsure how to get this to work. Basically, the user selects the chemical they want to convert from a drop-down list, selects the quanity and the units of measurement, and some calculations are made based on this.

To be honest though it isn't working out for me - in particular, the simple VLOOKUP function I've included doesn't seem to be working properly. Could anyone give me some advice on what I'm doing wrong or point me in the right direction of the approach I need to take to make this? I'm relatively new to Excel so I'm still learning this stuff.

I've attached a copy of what I've been building to this message

Thanks!

SGC.xlsx