Vlookup formula

[shonu1320]

I want help in understanding and modifying this formula

=IF(ISERROR(IF(ISBLANK(A6),"",IFERROR(IFERROR(IFERROR(VLOOKUP(A6,ABC!A:I,2,0),VLOOKUP(A6,DEF!A:I,2,0)),VLOOKUP(A6,JKL!A:I,2,0)),VLOOKUP(A6,GHI!A:I,2,0)))),"NOT FOUND",IF(ISBLANK(A6),"",IFERROR(IFERROR(IFERROR(VLOOKUP(A6,ABC!A:I,2,0),VLOOKUP(A6,DEF!A:I,2,0)),VLOOKUP(A6,JKL!A:I,2,0)),VLOOKUP(A6,GHI!A:I,2,0))))

ABC, DEF, GHI, and JKL are the 4 different regions for which we are tracking the inventory. Instead of going to those 4 regions seprately, I want to combine it so that it will pull these records from one data dump. It will all come from column G of the data dump workbook.

Help and advice on this will be very well appreciated!
Thanks.

 

[JPM]

I would think that you could simplify your formula to =IFERROR(IF(ISBLANK(A6),"",IFERROR(IFERROR(IFERROR(VLOOKUP(A6,ABC!A:I,2,0),VLOOKUP(A6,DEF!A:I,2,0)),VLOOKUP(A6,JKL!A:I,2,0)),VLOOKUP(A6,GHI!A:I,2, 0))),"NOT FOUND")

Which is basically taking out the redundancy that you had by switching the ISERROR to an IFERROR. Now all it is doing is:

If cell A6 is blank than leave this cell blank otherwise
If there is an error doing the VLOOKUP(A6,ABC!A:I,2,0) then do VLOOKUP(A6,DEF!A:I,2,0)
If that doesn't work then do VLOOKUP(A6,JKL!A:I,2,0)
If that also doesn't work do VLOOKUP(A6,GHI!A:I,2, 0)
If all of the above options are creating an error then say "NOT FOUND"

Hope this will work for you.