VLOOKUP Problem

  • Thread starter Thread starter ROBERT LANGLEY
  • Start date Start date
R

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

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
 
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")"
 
Back
Top