VLOOKUP problem

  • Thread starter Thread starter Bob Langley
  • Start date Start date
B

Bob Langley

I have a workbook with 4 tables: times1, times2 & times3 are tables of data
to be referenced. The 4th table named SECURED uses the formula:
"=IF(ISNA(VLOOKUP(TRIM($C53&E$51),times1,1,FALSE)),IF(ISNA(VLOOKUP(TRIM($C53
&E$51),times2,1,FALSE)),IF(ISNA(VLOOKUP(TRIM($C53&E$51),times3,1,FALSE)),"Sk
ip","OK")))" to search for a concatenated value of the contents of cells c53
&e51 successively in each of the three tables depending upon whether the
value is found. If the value is missing, the value"Skip" should be
returned, if found, "OK". the above formula returns the value "FALSE".
When trying to reference either 2 of the tables, I can get the desired
result. I'm obviously screwing up the syntax using the 3rd table. After 4
hours of trials, I'm loosing a lot of hair. Any help? If someone sees an
alternate way of doing this, my ego won't suffer at all from some
suggestions.
 
Think you're missing the 2 "value_if_false" for the outer 2 IFs

Try instead:

=IF(ISNA(VLOOKUP(TRIM($C53&E$51),times1,1,FALSE)),IF(ISNA(VLOOKUP(TRIM($C53&
E$51),times2,1,FALSE)),IF(ISNA(VLOOKUP(TRIM($C53&E$51),times3,1,FALSE)),"Ski
p","OK"),"OK"),"OK")

Amendment is made only to the end part of your formula
[ ,"OK"),"OK") ]
 
That fixed it. And I just thought it was working with 2 ifs - it
wasn't. Thanks a lot.



Max said:
Think you're missing the 2 "value_if_false" for the outer 2 IFs

Try instead:

=IF(ISNA(VLOOKUP(TRIM($C53&E$51),times1,1,FALSE)),IF(ISNA(VLOOKUP(TRIM($C53&
E$51),times2,1,FALSE)),IF(ISNA(VLOOKUP(TRIM($C53&E$51),times3,1,FALSE)),"Ski
p","OK"),"OK"),"OK")

Amendment is made only to the end part of your formula
[ ,"OK"),"OK") ]

--
Rgds
Max
xl 97
----------------------------------
Use xdemechanik <at>yahoo<dot>com for email
-----------------------------------------
Bob Langley said:
I have a workbook with 4 tables: times1, times2 & times3 are tables of data
to be referenced. The 4th table named SECURED uses the formula:
"=IF(ISNA(VLOOKUP(TRIM($C53&E$51),times1,1,FALSE)),IF(ISNA(VLOOKUP(TRIM($C53
&E$51),times2,1,FALSE)),IF(ISNA(VLOOKUP(TRIM($C53&E$51),times3,1,FALSE)),"Sk
ip","OK")))" to search for a concatenated value of the contents of cells c53
&e51 successively in each of the three tables depending upon whether the
value is found. If the value is missing, the value"Skip" should be
returned, if found, "OK". the above formula returns the value "FALSE".
When trying to reference either 2 of the tables, I can get the desired
result. I'm obviously screwing up the syntax using the 3rd table. After 4
hours of trials, I'm loosing a lot of hair. Any help? If someone sees an
alternate way of doing this, my ego won't suffer at all from some
suggestions.
Click to expand...
Click to expand...
 
Back
Top