Howdy,
I have combined the VLOOKUP formula with the IF and COUNTIF formula to avoid the #NA error and speed up the calculations.
The data being looked up exists on seperate workbooks.
The problem I have is when the aforementioned workbooks are closed and I make changes such as inserting a line or update the links, all my VLOOKUP cells turn to #VALUE errors :o
Problem is solved if I open the source workbooks. The formulas then work correctly.
What is causing this #VALUE error ??
Rgds
Justin