Nesting VLOOKUP within CONVERT function

[TKfishes]

Hello all,

I am trying to nest formulas within a CONVERT function to make it more user friendly. My formula is returning #N/A. Is it possible to do this without a macro? Ultimately A1 and B1 would contain drop down lists so a user could select the units they wish to convert between without having to modify a formula or use the syntax associated with the CONVERT formula.

A1 contains oz
B1 contains lbs
C1 contains 16


table 1:

Unit	Syntax
oz	"ozm"
lbs	"lbm"

<tbody>
</tbody>

formula =convert(c1,vlookup(a1,table1,2,false),vlookup(b1,table1,2,false))

 

[DRSteele]

Welcome to the forum.

In your Table1, you must remove the double-quotes that surround the two items in column Syntax.

 

[TKfishes]

Welcome to the forum.

In your Table1, you must remove the double-quotes that surround the two items in column Syntax.

That worked perfectly. Thanks for your help. I thought I had tried that but perhaps had an error elsewhere in conjunction.

 

[DRSteele]

You're welcome.