I have created an Array Formula in the header of a column of an existing worksheet that contains over 1,000 records.
If an entry has an Expense Category of “Travel”, it retrieves a Customer Code value in column B of a sheet named JobAllocations. It all works fine until row 988 where entries with an Expense Category of “Travel” show a value of “N/A”. The error message says “Array arguments to IF are of different size.”
Any thoughts on how I can fix this? Thanks!