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

Data	Inputs	Units		--Select Units--	--Select Fuel Source--
Measurement Units	--Select Units--			Metric	Electric
Fuel Source	--Select Fuel Source--			Standard	Natural Gas
Fuel Amount	some number input by user				Diesel
Electric Amount	some number input by user	kWh			Propane
			Metric	Standard
			Electric	liters	Electric	US Gallons
			Natural Gas	cubic meters	Natural Gas	cubic feet
			Diesel	liters	Diesel	US Gallons
			Propane	liters	Propane	US Gallons

<TBODY>
</TBODY>

 

[gsistek]

Try using (in C4):

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