ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   VLOOKUP and IF (https://www.excelbanter.com/excel-worksheet-functions/267117-vlookup-if.html)

RBaetz
VLOOKUP and IF
 
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

wickedchew
Quote:
Originally Posted by RBaetz (Post 960950)
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
Try:

=VLOOKUP(F4,S3:V10,IF(F5=20,3,4),0)


All times are GMT +1. The time now is 03:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com