Hi,
I currently have a INDEX(RefDataRange, MATCH( LookupCell, RefLookupRange, 0), FixColNum) that works.
I now want to replace LookupCell with a range (ie. C1:C20) and sum all the return values.
Is there a way of doing this without a VBA For Loop?
Regards
Bookmarks