CODEWITHSUNDEEP
excelformula
Brandon Jake Sullano
Brandon Jake Sullano

Reputation: 335

Excel Formula to Search keyword in a column and return its row number

I am trying to have excel formula and I don't want to use macro code here. I want to type in a word in column E4 and I should have a formula in E6 that will search for that word in the entire column A and return the row number.

For example I type "Grapes" Should give me answer of 4

here is my formula and I am not sure why it is not working, it is working with Grapes but for others it is not

Here is my formula: =MATCH(E4,A:A,1)

Upvotes: 0

Views: 1946

Answers (1)

Scott Craner
Scott Craner

Reputation: 152605

Use Wildcards (*) and look for exact instead of relative:

=MATCH("*"&E4&"*",A:A,0)

Upvotes: 2

Related Questions