Dear Forum.
I’m able to produce the result I’d be looking for via an array formula that I was using for a different use (dragged down for multiple returns - thank you again benishiryo!), but I think for this new different need, since I’d only be looking for a single result I’d imagine there would be a nicer way of doing it with a regular INDEX formula or something (if I can eliminate unnecessary array formula that would be great as I also have quite a few array formulas for other uses in the workbook). While the sample workbook only has a single cell that would need said formula in the real world workbook there could be hundreds so if I can do without using array formula that would be great.
In the sample workbook I have my array formula that I’m looking to replace in Cell F18.
Would appreciate any insight!
Bookmarks