| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
Quote:
=VLOOKUP(F4,S3:V10,IF(F5=20,3,4),0)
__________________
Asobi Wa Owari Da |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If (Vlookup 0) working, but what if Vlookup cell does not exist | Excel Worksheet Functions | |||
| Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
| Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
| Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Linear Mode
