VLOOKUP question (with sample table)

[Legacy 219053]

I tried to approach this problem using the =IF formula, but after some research decided that it might be easier to use VLOOKUP.

Pretty much, I want the value in C4 to depend on both the "units" (B2) and the "fuel type" (B3)


Sorry if the table is messy. I made this sheet with the assumption that I could attach it to my post. Obviously, cell B2 is a dropdown list made by Data Validation of the array E1:E3, and B3 is a dropdown made from F1:F5


[TABLE="width: 487"]
<TBODY>[TR]
[TD="class: xl65, width: 130, bgcolor: transparent"]Data
[/TD]
[TD="class: xl65, width: 168, bgcolor: transparent"]Inputs
[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]Units
[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl65, width: 95, bgcolor: transparent"]--Select Units--
[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]--Select Fuel Source--
[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Measurement Units
[/TD]
[TD="class: xl65, bgcolor: transparent"]--Select Units--
[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"]Metric
[/TD]
[TD="class: xl65, bgcolor: transparent"]Electric
[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Fuel Source
[/TD]
[TD="class: xl65, bgcolor: transparent"]--Select Fuel Source--
[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"]Standard
[/TD]
[TD="class: xl65, bgcolor: transparent"]Natural Gas
[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Fuel Amount
[/TD]
[TD="class: xl65, bgcolor: transparent"]some number input by user
[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"]Diesel
[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Electric Amount
[/TD]
[TD="class: xl65, bgcolor: transparent"]some number input by user
[/TD]
[TD="class: xl65, bgcolor: transparent"]kWh
[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"]Propane
[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent, colspan: 2"]Metric
[/TD]
[TD="class: xl66, bgcolor: transparent, colspan: 2"]Standard
[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"]Electric
[/TD]
[TD="class: xl65, bgcolor: transparent"]liters
[/TD]
[TD="class: xl65, bgcolor: transparent"]Electric
[/TD]
[TD="class: xl65, bgcolor: transparent"]US Gallons
[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"]Natural Gas
[/TD]
[TD="class: xl65, bgcolor: transparent"]cubic meters
[/TD]
[TD="class: xl65, bgcolor: transparent"]Natural Gas
[/TD]
[TD="class: xl65, bgcolor: transparent"]cubic feet
[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"]Diesel
[/TD]
[TD="class: xl65, bgcolor: transparent"]liters
[/TD]
[TD="class: xl65, bgcolor: transparent"]Diesel
[/TD]
[TD="class: xl65, bgcolor: transparent"]US Gallons
[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"]Propane
[/TD]
[TD="class: xl65, bgcolor: transparent"]liters
[/TD]
[TD="class: xl65, bgcolor: transparent"]Propane
[/TD]
[TD="class: xl65, bgcolor: transparent"]US Gallons
[/TD]
[/TR]
</TBODY>[/TABLE]

 

[gsistek]

Try using (in C4):

=IFERROR(INDEX(D7:G11,MATCH(B3,D7:D11,0),MATCH(B2,D7:G7,0)+1),"")