Here is an example of what I'm trying to do:
I have an array of cells with unique values: A1:Z1
There is one cell where a search term is entered: B1
I want: C1 = the column number where the term in B1 appears in A1:Z1.
Thanks for any help.
Here is an example of what I'm trying to do:
I have an array of cells with unique values: A1:Z1
There is one cell where a search term is entered: B1
I want: C1 = the column number where the term in B1 appears in A1:Z1.
Thanks for any help.
Try
=Match(B1,A1:Z1,0)
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Wouldn't that formula return 2 as an answer in all cases since it will just be matching itself?Originally Posted by NBVC
Good point BigBas, I should've looked deeper into it.... Thanks.Originally Posted by BigBas
I would assume, user meant the lookup value is in B2 and result would be in C2:
=Match(B2,A1:Z1,0)
Sorry, I see where the confusion is. What my original post should have said is:
Here is an example of what I'm trying to do:
I have an array of cells with unique values: A1:Z1
There is one cell where a search term is entered: A2
I want: A3 = the column number where the term in A2 appears in A1:Z1.
Match works great, thanks!
In that case.... =Match(A2,A1:Z1,0)Originally Posted by Spreadsheet
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks