Using match to search for string which contains ""

ljtong

Board Regular
Joined
May 23, 2005
Messages
71
Hello all,

I'm trying to use match to search for this string:

mA reading "Strain OFF" Front Left

The "" around strain OFF is giving me problems

Excel keeps suggesting this formula but it doesn't work:

=match('mA reading "Strain OFF" Front Left',a1:z1)

how can I tell Excel "Strain OFF" is part of the string and not another string?
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
I

may not totally follow you (that happens to me a lot, though :biggrin: ), but see if one of thes 2 things might point you towards a solution:

1- MATCH has 3 parts and I only saw 2 in your example. Look in Help, but O is supposed to be for an exact match. This might solve it.

or

2- I don't know if FIND or a combination of FIND and INDEX might work better than a MATCH in this case. I don't use FIND and INDEX very much myself, but they might be worth trying if you remain stuck for long.

HTH
 
Upvote 0
Re: Using match to search for string which contains "&q

ljtong said:
Hello all,

I'm trying to use match to search for this string:

mA reading "Strain OFF" Front Left

The "" around strain OFF is giving me problems

Excel keeps suggesting this formula but it doesn't work:

=match('mA reading "Strain OFF" Front Left',a1:z1)

how can I tell Excel "Strain OFF" is part of the string and not another string?

Either:

=MATCH("mA reading ""Strain OFF"" Front Left",A1:Z1,0)

Or:

A5 houses:

mA reading "Strain OFF" Front Left

and you invoke:

=MATCH(A5,A1:Z1,0)
 
Upvote 0
Thanks for that Aladin

bk, I think the third parameter for match is optional and it assumes 1 if left out
 
Upvote 0
ljtong said:
Thanks for that Aladin

You're welcome

bk, I think the third parameter for match is optional and it assumes 1 if left out

It's not optional. You have to specify either 0 (FALSE) for (A) unsorted ranges or 1 (TRUE) for (B) ranges sorted in ascending order. When (B), it is optional to choose from either 1, or TRUE, or omitted.
 
Upvote 0

Forum statistics

Threads
1,213,495
Messages
6,113,992
Members
448,538
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top