make sumproduct lookup case sensitive

P

PBcorn

I'm using sumproduct to look up a value in column 5 based on values in
columns 1 and 2:

SUMPRODUCT((TRIM('Sheet1'!$A$9:$A$97)=TRIM(A13))*(TRIM('Sheet1'!$B$9:$B$97)=TRIM(B13)),'Sheet1'!$H$9:$H$97)

however i need it to treat two strings, identical aprt from the case of
certain letters, as separate items.

Any suggestions?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Totals Lookup by month and year 3
Hlookup 3 criteria?? 0
IF Lookup Formula 2
Index Match Help 6
2 criteria lookup of text. Return text form column 3. SUMPRODUCT t 2
Locate text in range (multiple occurrences) and report other cell insame column? 25
Sumproduct function allow a lookup for one Date to check if it fallsin Date Range in other table 9
XL2000 Array Function Problem 2

Top