Hello,
I have MATCH("abc",A:A,0), I want to change it to MATCH("abc",A:G,0), but match only likes looking in a single row/column and returning the corresponding column/row. I want to look at a whole array, A:G, and return the row position of the result. I feel like there should've been a single formula in excel, but I can't find anything in the lookup & reference section. I'm probably just being really dense right now. Oh, and this is part of a larger equation, so hopefully we can result in something no bigger than the "ideal" match equation i had above. Here's an ex in case you're further confused:
COLUMN
A....B....C....D....E
12....AS....FV....HT....JU
XE....4R....H7....QW....EW
LX....2Q....7U....2S....45
So, H7 is in C2, I want it to return 2.
Bookmarks