VLOOKUP Problem

[ROBERT 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.

 

[Paul]

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.

You need to include "value if false" for the outer two IFs:
=IF(ISNA(VLOOKUP(TRIM($C53&E$51),times1,1,FALSE)),IF(ISNA(VLOOKUP(TRIM($C53

 

[y sakuda]

I supporse you need to add value for FALSE to first and second IF function.

"=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","OK3"),"OK2"),"OK1")"