Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi,
I'm trying to use the VLOOKUP formula as the argument inside an IF formula. I'm doing this because my VLOOKUP references a different file that has 30,000 rows in it, and that seems to be making my VLOOKUP fail due to lack of system resources. Anyway, here is how I am trying my IF statement: =IF(A120000, =VLOOKUP(A1, etc, etc...,FALSE),VLOOKUP(A1, etc, etc...,FALSE)) My IF statement is using two different VLOOKUP functions as arguments, so that I can look up data in two unique source files. But, my IF statement returns an error if I do this. Any thoughts? I tried adding parenthesese, also double-quotes, but I can't get it to work. Thanks.... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problem with named formula's | Excel Worksheet Functions | |||
Formulas | Excel Worksheet Functions | |||
How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |