I have sheet Customer A and sheet breakdown, trying to extract from breakdown column J split, the first , the second , using aggregate formula with index based on column H of customer A but gettin Num error.
Can anyone assist.
I have sheet Customer A and sheet breakdown, trying to extract from breakdown column J split, the first , the second , using aggregate formula with index based on column H of customer A but gettin Num error.
Can anyone assist.
How aboutFormula:Please Login or Register to view this content.
Thanks workings now.
But Is there another method I d'ont want to use iferror infront of index as the sheet has big data.
What's wrong with using IfError?
The OP has a point, if I understand correctly. See my explanation here, including suggested alternative.
Regards
@XOR LX
I understand what you're saying, but I think that this is slightly different.
My take is that some of the values in Col H of the "Customer A" sheet do not exist on the "Breakdown" sheet & therefore the OP wants to hide those errors.
The only issue with iferror that I have to extract on large dataset of 300000 rows sometimes more .
So I was asking if there is another technique instead of iferror.
If you are simply trying to avoid the #NUM error, I'd use Iferror, however another option would beFormula:Please Login or Register to view this content.
Thank you Fluff
You're welcome & thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks