Equation using drop down as variable

[zxcless]

Hello! I'm trying to get an equation to work for a peppercorn blend form I have, where changing cell B2 from Gram to TSP (teaspoon) will change the output in the Total cells. See below for the form.

TSP Field Selected - https://i.imgur.com/FIHDDor.png
Gram Field Selected - https://i.imgur.com/rrDPZo2.png

Video of Form - https://screencast-o-matic.com/watch/cFnOqvDnAi


My current equation for the TSP field being selected, which works, is:
=IF($B$1="TSP",(IFERROR(VLOOKUP(A2,matrix,2,0),"")))*B2


When I select Gram from the drop down (B1) I'd like the value under Total to equal what I type in under the Gram cell. So 4 in B2 would output 4 in C2.

I'm not sure if this makes sense. The formula I had thought to use was the following, but it comes up with an error:
=IF($B$1="TSP",((IFERROR(VLOOKUP(A2,matrix,2,0),"")))*B2,),$B$1="Gram",B2*1))


Any help would be greatly appreciated!

 

[zxcless]

Whoops! The first two links don't show the equation. Please see below.

TSP Field Selected - https://i.imgur.com/D8Nvra2.png
Gram Field Selected - https://i.imgur.com/6i9OOTu.png

 

[Dryver14]

Is there not a simple equation you can use in D2 to convert the result

I making number up now but something like = C2/300

 

[zxcless]

The goal is to make blend forms for all the different recipes we have. The first box (A1:C5) is where the recipe goes, then the totals are linked to another sheet to make a blend form for a larger quantity, say 25 lbs.

The issue is some recipes are by grams and others are by ******* measurements such as teaspoon. I figure it would be easiest to be able to switch back and forth using the drop down in B1.

 

[zxcless]

Solved!

I got it to work. I was thinking it needed to be two IF function; TSP=X, Gram=Y. However, I forgot that the IF function has a 'value_if_false' field. Noticing this I used the below formula.

=IF($B$1="TSP",(IFERROR(VLOOKUP(A2,matrix,2,0),""))*B2,B2)

Thanks!

 

[Dryver14]

Glad you got sorted