How can I use more than 64 levels of nesting

[MasmaAbdulhamidli]

Hi. I can not complete my work because of the 64 levels of nesting issue. I have multiple sheets with data. And want to bring data to new base sheet with vlookup and iferror. But in the end when i finished formula there appear error. My formula is =IFERROR(VLOOKUP(B5;'Sheet1'!$B$2:$G$389;6;0);IFERROR(VLOOKUP(B5;'Sheet2'!$B$2:$E$54;4;0);IFERROR(VLOOKUP(B5;'Sheet3'!$B$2:$G$3;6;0);...... and so on. Can you help?

 

[Anthony47]

If VLOOKUP returns a number you could try using

=IFERROR(VLOOKUP(B5,Sheet1!$B$2:$G$389,6,0),0)+IFERROR(VLOOKUP(B5,Sheet2!$B$2:$G$389,6,0),0)+etc

If it returns a string could try

=IFERROR(VLOOKUP(B5,Sheet1!$B$2:$G$389,6,0),"")&IFERROR(VLOOKUP(B5,Sheet1!$B$2:$G$389,6,0),0)&etc

But are you sure you need to look on every sheet? I mean: would it be possible determine which sheet should be targeted and use INDIRECT to point to that sheet with one single Vlookup?

 

[MasmaAbdulhamidli]

If VLOOKUP returns a number you could try using

=IFERROR(VLOOKUP(B5,Sheet1!$B$2:$G$389,6,0),0)+IFERROR(VLOOKUP(B5,Sheet2!$B$2:$G$389,6,0),0)+etc

If it returns a string could try

=IFERROR(VLOOKUP(B5,Sheet1!$B$2:$G$389,6,0),"")&IFERROR(VLOOKUP(B5,Sheet1!$B$2:$G$389,6,0),0)&etc

But are you sure you need to look on every sheet? I mean: would it be possible determine which sheet should be targeted and use INDIRECT to point to that sheet with one single Vlookup?

Sorry for answering late. Thanks a lot. It works