| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
make sumproduct lookup case sensitive
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
make sumproduct lookup case sensitive
Use the EXACT function.
Hope this helps. Pete On Jan 9, 10:06*am, PBcorn wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I Make AutoFilter to be Case-Sensitive? | Excel Discussion (Misc queries) | |||
| Case Sensitive Compare, Lookup, etc???? | Excel Discussion (Misc queries) | |||
| Case Sensitive w/ IF | Excel Worksheet Functions | |||
| can vlookup be forced to make a case sensitive match? | Excel Discussion (Misc queries) | |||
| any way to make vlookup case sensitive? | Excel Worksheet Functions | |||
Linear Mode
