Modify and Optimize Formula

[fredlo2008]

Hello guys,

I need to modify and possibly optimize this formula.

=IFERROR(IF(Headers(A9)="","",IF(A9=IFERROR(VLOOKUP(A9,'Reference Workbook.xlsx'!OldCodes,2,FALSE),""),"Old code"&","&" please use "&VLOOKUP(A9,'Reference Workbook.xlsx'!OldCodes,3,FALSE),IF(A9=IFERROR(VLOOKUP(A9,'Reference Workbook.xlsx'!SaleValidation,1,FALSE),""),"Sales item only"&","&" please use "& VLOOKUP(A9,'Reference Workbook.xlsx'!SaleValidation,2,FALSE),VLOOKUP(A9,'Reference Workbook.xlsx'!Data,2,FALSE)))),"Item could not be found!")

In this formula "Header" is a small UDF I created to avoid multiple nested ifs (more than 30)

Thanks a lot

 

[fredlo2008]

Is it personal or what? Joking its a little frustrating that I never get help when I need it on this forum. I always help others