Trying to use index(match to bring over some data from one sheet to another one.
Part of the criteria is based upon text found in a string. I was hoping to just use wild cards but it appears, after trying a few times, that it isn't working.
Where am I going wrong?
On sheet1 in cell D2 I am inputting the following:
=INDEX(SHEET2NAMEDRANGE1,MATCH(1,(SHEET2NAMEDRANGE2=A2)*(SHEET2NAMEDRANGE3="*ABC*")*(SHEET2NAMEDRANGE4="*XYZ*"),0),1)
SHEET2NAMEDRANGE1 is on sheet2 and is a single column, column F, it is a date.
SHEET2NAMEDRANGE2 is on sheet2 and is a single column, column A, it is numeric.
SHEET2NAMEDRANGE3 is on sheet2 and is a single column, column G, it is a text string.
SHEET2NAMEDRANGE4 is on sheet2 and is a single column, column D, it is a text string.
I get #N/A when I run confirm it with CSE.
Any thoughts?
-Spydey
P.S. Hmmm, just thinking through this, I wonder if I need to use something like .... (SHEET2NAMEDRANGE3=ISNUMBER(SEARCH("*ABC*",SHEET2NAMEDRANGE3))) ...... but something tells me that isn't right because I would be using a named range in my SEARCH( range ..... I think .....
Part of the criteria is based upon text found in a string. I was hoping to just use wild cards but it appears, after trying a few times, that it isn't working.
Where am I going wrong?
On sheet1 in cell D2 I am inputting the following:
=INDEX(SHEET2NAMEDRANGE1,MATCH(1,(SHEET2NAMEDRANGE2=A2)*(SHEET2NAMEDRANGE3="*ABC*")*(SHEET2NAMEDRANGE4="*XYZ*"),0),1)
SHEET2NAMEDRANGE1 is on sheet2 and is a single column, column F, it is a date.
SHEET2NAMEDRANGE2 is on sheet2 and is a single column, column A, it is numeric.
SHEET2NAMEDRANGE3 is on sheet2 and is a single column, column G, it is a text string.
SHEET2NAMEDRANGE4 is on sheet2 and is a single column, column D, it is a text string.
I get #N/A when I run confirm it with CSE.
Any thoughts?
-Spydey
P.S. Hmmm, just thinking through this, I wonder if I need to use something like .... (SHEET2NAMEDRANGE3=ISNUMBER(SEARCH("*ABC*",SHEET2NAMEDRANGE3))) ...... but something tells me that isn't right because I would be using a named range in my SEARCH( range ..... I think .....
Last edited: