Here is a copy of the code.I need to add code that will use values for b6= 2,
3, 4 and the arrays for the tables in the vlookupfunction will change as
well. Just wondering if it would actually work.


=(IF(AND(J8=1,B6=1),IF(ISNA(VLOOKUP(E19,'Calculati ons
2'!B3:C64,2,0)),INDEX('Calculations
2'!B3:C64,MATCH(Calculations!E19,'Calculations
2'!B3:B64,1)+1,2),VLOOKUP(E19,'Calculations
2'!B2:C64,2,0)),IF(AND(J8=2,B6=1),IF(ISNA(VLOOKUP( E19,'Calculations
2'!I3:J64,2,0)),INDEX('Calculations
2'!I3:J64,MATCH(Calculations!E19,'Calculations
2'!I3:I64,1)+1,2),VLOOKUP(E19,'Calculations
2'!I3:J64,2,FALSE)),IF(AND(J8=3,B6=1),IF(ISNA(VLOO KUP(E19,'Calculations
2'!Q3:R64,2,0)),INDEX('Calculations
2'!Q3:R64,MATCH(Calculations!E19,'Calculations
2'!Q3:Q64,1)+1,2),VLOOKUP(E19,'Calculations 2'!Q3:R64,2,0))))))

I need to add code that will use values for b6= 2, 3, 4 and the arrays for
the tables in the vlookupfunction will change as well. Just wondering i


"John C" wrote:

Do you have an example of what you are trying to accomplish?
--
John C


"ashoulds" wrote:

Does anyone know how many functions excel can handle in a single cell? I
have a pretty long formula that searches three tables for values and need to
add three more variables that will search three separate tables.