How can I find a value from one cell in a char string in another?
tiredazdaddy wrote:
I am trying to figure out how to search for a specific alphanumeric value
from a cell in a character string in another cell. Does anyone know how to do
this, or if it can be done via a Excel command?
For instance, the below works fine if I only want to find an exact match for
the values within column D for that in cell H3, but I do not know how to
find the same value from H3 if the values in column D contain a match
mixed in a character string.
Any help would be greatly appreciated!
=SUM(IF(('Input Form'!C$4:C$549=$G$3)*('Input Form'!D$4:D$549=$H$3)*('Input
Form'!R$4:R$549<=$A126)*(NOT(ISBLANK('Input Form'!R$4:R$549))),1,0))
Use either FIND() or SEARCH(), depending upon whether you want it to be
case-sensitive:
=SUM(IF(('Input Form'!C$4:C$549=$G$3)*(FIND($H$3,'Input
Form'!D$4:D$549))*('Input Form'!R$4:R$549<=$A126)*(NOT(ISBLANK('Input
Form'!R$4:R$549))),1,0))
|