Hi All,

I created a table with drop down boxes and depending on which size and angle are picked it shows the area. All of this data is in a table off to the side. I’m using "=(IF(F5=20,(VLOOKUP(F4,S3:V10,3,TRUE)))" but when I try "=(IF(F5=20,(VLOOKUP(F4,S3:V10,3,TRUE))),(IF(F5=30 ,(VLOOKUP(F4,S3:V10,4,TRUE)))))" for when the angle is changed from 20 to 30 degrees it gives me the #VALUE error. Any help is greatly appreciated.

System Size 50
Tilt Angle 20
Number of Modules 273
Type of Racking -
Module Wattage 220
Azimuth 0
Area of Solution 8546