Lookup

[Simmy1234]

Hi There

Please help, my data has 3 columns Fuel, AFUE %low and AFUE% high.

The user enters the fuel and the AFUELow or AFUEhigh and the lookup must input the the right percent under AFUElow or AFUEhigh column.

Feul AFUE % low AFUE % high
Heating oil-Cast iron (pre-1970) 60% 20%
Heating oil-Retention head burner 70% 78%
Heating oil-Mid efficiency 83% 89%
Electric heating-Central or baseboard / Elements 100% 100%
Electric heating-Geothermal heat pump see cop
Electric heating-Air-source heat pump see hspf
Natural gas-Conventional 55% 65%
Natural gas-Mid-efficiency 78% 84%
Natural gas-Condensing 90% 97%
Propane-Conventional 55% 65%
Propane-Mid-efficiency 79% 85%
Propane-Condensing 88% 95%
Firewood-Conventional 45% 55%
Firewood-Advanced 55% 65%
Firewood-State-of-the-Art 75% 90%
Coal-New Technology 75% 85%

Thanks

 

[John Davis]

Hi There

Please help, my data has 3 columns Fuel, AFUE %low and AFUE% high.

The user enters the fuel and the AFUELow or AFUEhigh and the lookup must input the the right percent under AFUElow or AFUEhigh column.

Feul AFUE % low AFUE % high
Heating oil-Cast iron (pre-1970) 60% 20%
Heating oil-Retention head burner 70% 78%
Heating oil-Mid efficiency 83% 89%
Electric heating-Central or baseboard / Elements 100% 100%
Electric heating-Geothermal heat pump see cop
Electric heating-Air-source heat pump see hspf
Natural gas-Conventional 55% 65%
Natural gas-Mid-efficiency 78% 84%
Natural gas-Condensing 90% 97%
Propane-Conventional 55% 65%
Propane-Mid-efficiency 79% 85%
Propane-Condensing 88% 95%
Firewood-Conventional 45% 55%
Firewood-Advanced 55% 65%
Firewood-State-of-the-Art 75% 90%
Coal-New Technology 75% 85%

Thanks

would VLOOKUP on separate sheet be of any help?

B2 =IF(ISNA(VLOOKUP(A2,Sheet1!$A$3:$D$5,2,FALSE)),"",VLOOKUP(A2,Sheet1!$A$3:$D$5,2,FALSE))

C2 =IF(ISNA(VLOOKUP(A2,Sheet1!$A$3:$D$5,3,FALSE)),"",VLOOKUP(A2,Sheet1!$A$3:$D$5,3,FALSE))

 

[Simmy1234]

Hi There

sorry for the delayed response, we had connectivity issues. the solution posted is not working.

my scenario is: The user inputs two things the fuel e.g (Heating - oil-Cast iron (pre-1970) and on another cell user inputs either AFUE % low or AFUE % high.

Based on the user inputs, i need to assign the right percentage:
my data table is arrange in these three columns.

Feul AFUE % low AFUE % high
Heating oil-Cast iron (pre-1970) 60% 20%
Heating oil-Retention head burner 70% 78%
Heating oil-Mid efficiency 83% 89%
Electric heating-Central or baseboard / Elements 100% 100%

 

[Simmy1234]

Hi Guys.

I've finaly sorted out my problem using index(match).

Thanks