IF, ISNA & VLOOKUP formula optimisation.

Hello everybody.

I have quite a complicated (for me) spreadsheet that has a lot of look ups. I would like to optimise parts of this spreadsheet by altering my code to try and speed up the workbook.

Basically I search for a customer number and return a figure when found using a VLOOKUP. I want to protect my spreadsheet from N/A errors so have an IF statement to make sure I always return a number. Please see below:

Please Login or Register  to view this content.

Is there a way of removing the second lookup by using different code so I am only doing 1 per formula. The workbook has something like ~3000 formulas that have lookups in, so if each formula has 2 lookups the workbook is processing 6000 look ups!!!! Crikey!

Any and all help is appreciated.
Please request any more information you may need that I have left out!

Kris

Please Login or Register  to view this content.

For you that would need to be something like:

Please Login or Register  to view this content.