XMATCH W/ TWO CRITERIA (within the same column)

[JuicyMusic]

Hello, I have a formula that works just fine but I need to add a 2nd criteria to it.

The only criteria it has now is that a particular text should be written as follows, and the formula will provide a result: JOB#(then a space).
Since people are starting to type "JOB(space)#" now - I need to account for it. I've tried to adjust my formula with no success.

Formula is looking for eIther JOB# or JOB #

Here is my existing formula:

=INDEX(F$2:F2,XMATCH("Job#*",F$2:F2,2,-1))

I can't wait.....to see if I was anywhere close. Thanks,
Juicy

 

[Fluff]

Why not just get rid of the # sign?

 

[Radoslaw Poprawski]

@Fluff @JuicyMusic

Book1
	E	F	G	H
1
2		Job#*	Job#*
3		Job #*	Job #*
4		Job #*	Job #*
5
Sheet2

Cell Formulas
Range	Formula
G2:G4	G2	=INDEX(F$2:F2,XMATCH("Job*",F$2:F2,2,-1))

@Fluff
is correct. its the simplest solution

 

[JuicyMusic]

I tried getting rid of the pounds sign all together but there is a text with the word Job in it that I don't want a return for.

For example: JOB NUMBER

I just tried your formula and it is giving me results for these two texts as well: JOB NAME, JOB NUMBER

 

[Fluff]

In that case try it like Job*#*

 

[Radoslaw Poprawski]

if it wont work, then provide data sheet.

 

[JuicyMusic]

Awesome! SOLVED! What a little change that changed my life

=INDEX(F$2:F2,XMATCH("Job*#*",F$2:F2,2,-1))

 

[Fluff]

You're welcome & thanks for the feedback.