Lookups

[Wojciech]

I think it's a simple one, but you know how CTRL+F finds a value very easily, regardless if it's a cell of itself or if it's embedded in a long string of other words/numbers, even without spaces or anything in between?

How can I form a formula that'd do the same? One that'd look at cell

FsFSFW353534sFF35535///

And treat it as an occurence if I'm looking for, say, the FF35 within it.

Also while on that note, how do I decide if the first, last or X occurrence is chosen, if say I'm only interested in the first time it shows up.

 

[Asheesh]

hi,

Can you share a sample file with some examples and the desired output..

Let me just tell you, it is very much possible with the formula, however, would be great if we have a sample file.

 

[Deepak]

Is this.

=MATCH("*"&F1&"*",A1:A13,0)

Where F1= FF35 & A1:13 has data set.