Find text in range

[bfournier5]

Hello

Looking for some help. I'm trying to find the row value of a specific text that appears inside a range. Once I have this row, I'll need to copy the data that is located 3 columns to the left of this same row. I have placed the search text inside a cell and if that do not work, I need to search the same range with another set of words that is placed right under.

I'll also need some help to bypass this if the range is less then 5 lines.

Here is my formula so far

=MATCH(P1;SingleInteraction;0) but it returns #n/a ... but my range has the search text in it. If I only have this text inside the cell, it will return the row, but the cell will always have more text before what I'm looking for.

Hope this make sense?

 

[bfournier5]

solved one issue ... able to search and return a value ... here is the updated formula ... =MATCH(" * "&P1;SingleInteraction;0)

still need help with

a) how to bypass this if the range is less then 5 rows

b) check for something that is in either P1 or P2

 

[bfournier5]

have solved a) ... but now have an error when using the formula

ActiveCell.Formula = "=MATCH(" * " & P1;SingleInteraction;0)", believe the issue is the quotes and ampersand within the formula that is causing me an issue.

 

[bfournier5]

Simply needed to add another set of quotes to make it work ... final formula is ActiveCell.Formula = "=MATCH("" * "" & P1;SingleInteraction;0)"