Forum Discussion
Excel VLOOKUP / Poor Naming Convention
Hi All, I am looking for some advice with regard to V LOOKUP. My company has not followed a strict naming convention within its database. For Example, some records have been created as 'Amazon' so...
=SUMPRODUCT(ISNUMBER(SEARCH(B$2,$E$5:$E$14))*$F$5:$F$14)Since you want to calculate the spend for a supplier you can try SUMPRODUCT.