A
azdesuser
Hello,
I have a column of text strings (Column C), which I need to match to
text string in a table called “UIDtable”. This UIDtable is the firs
column in a two column array titled “DIVISIONarray”, the second colum
of this DIVISIONarray is a value I need to return in the cell I a
running the following formul
=IF(ISNUMBER(MATCH(C5,UIDtable,0)),VLOOKUP(C5,DIVISIONarray,2,0),"?DIVISION?")
This works fine, but I now need to have the text to match in th
UIDtable have wild cards in them, which does not work with the abov
formula. What I need to do is to move from more of a find function to
search function, in the above formula. Any help would be appreciated
I have a column of text strings (Column C), which I need to match to
text string in a table called “UIDtable”. This UIDtable is the firs
column in a two column array titled “DIVISIONarray”, the second colum
of this DIVISIONarray is a value I need to return in the cell I a
running the following formul
=IF(ISNUMBER(MATCH(C5,UIDtable,0)),VLOOKUP(C5,DIVISIONarray,2,0),"?DIVISION?")
This works fine, but I now need to have the text to match in th
UIDtable have wild cards in them, which does not work with the abov
formula. What I need to do is to move from more of a find function to
search function, in the above formula. Any help would be appreciated