# Question: Based on the user’s selection of enclosure types, there are 4 different tables based off of temperature and watt/ft^2. SOLVED

\$30.00

Category:

## Description

Question: Based on the user’s selection of enclosure types, there are 4 different tables based off of temperature and watt/ft^2. SOLVED

Based on the user’s selection of enclosure types, there are 4 different tables based off of temperature and watt/ft^2. In one spread sheet, it calculates the change in temperature (delta t) and we want it to point to the watts/ft^2 on the specific enclosure type that the user has selected. Rather than a nested If statement, we want to use the index match function. Please explain step by step which option is a better route just in case there are other enclosures added. We are trying to fill the section where “Watt/ft^2″ is empty.

Rather than using this:
=IF(B4=”Stainless Steel”,VLOOKUP(B16,Sheet3!A3:B53,2,TRUE),IF(B4=”ANSI 61 Gray”,VLOOKUP(B16,Sheet3!D3:E57,2,TRUE),IF(B4=”Aluminum”,VLOOKUP(B16,Sheet3!G3:H51,2,TRUE),IF(B4=”White”,VLOOKUP(B16,Sheet3!J3:K37,2,TRUE)))))

error: Content is protected !!