Hi all, new to the site but it seems to be the place to get the right help with a troublesome excel formula!
Here's the formula:
=IF(AND(VLOOKUP(C634,'[CustomerBactosolInvoicing.xls]Customer Bactosol Invoicing'!$A$2:$J$2000,9,FALSE),N634>""),"",VLOOKUP(C634,'[CustomerBactosolInvoicing.xls]Customer Bactosol Invoicing'!$A$2:$J$2000,9,FALSE))
My problem is that I've had to enter the AND function to get the results to perform correctly (as there can be multiple duplication of the lookup values)
However, I can no longer use the ISERROR or ISNA functions as putting them in gives me an error telling me there are too many arguments, or the formula is incorrect, which means I end up with a column mainly made up of #N/A when I want a nice empty cell if there's nothing to fill in.
Is there a shorter way to do this formula? Or am I missing a trick? Unfortunately I cannot attach a copy of the workbooks I am working from as they are confidential.
Thanks for any help!
Martin
Bookmarks