Forum Discussion
APagels
May 31, 2024Copper Contributor
Match function returns the same index for multiple non-equal values
I'm working on a digital design project, using Excel to help sort my data entries to see what elements I can eliminate. What this means: I have a list of 800 values in two lists that are all string...
dscheikey
May 31, 2024Bronze Contributor
The absolute referencing seems to be wrong in your formulas. Try it out:
=VLOOKUP("*"&C2&"*",A$2:A$413,1,FALSE)
=MATCH(E2,A$2:A$413,0)+1
New alternatives from VLOOKUP())
=XLOOKUP("*"&C2:C14&"*",A2:A14,A2:A14,"",2)
=IFERROR(XMATCH(H2#,A2:A14)+1,"")
without Helpcolumn:
=IFERROR(XMATCH("*"&C2:C14&"*",A2:A14,2)+1,"")