Ifs Statement

[jamesmev]

I am trying to get an if statement to work in where
1. if cell = text refer to another cell
2. if cell = text refer to another cell
3. If cell does not have either text then index match...

The first two are working fine.
The third is giving me a value error.

If anyone can help!

=IFS(I241="b / No Call DaySouthwest",M314,I241="New / Change Delivery DaySouthwest",M314,INDEX('Forms Data'!BJ50:BJ86,MATCH(' Forms'!I241,'Forms Data'!BG50:BG86,FALSE)),1)

Much appreciated!

 

[Fluff]

How about
=IF(OR(I241={"b / No Call DaySouthwest","New / Change Delivery DaySouthwest"}),M314,INDEX('Forms Data'!BJ50:BJ86,MATCH(I241,'Forms Data'!BG50:BG86,0)))

 

[jamesmev]

thank you that worked perfectly! Awesome!

 

[Fluff]

You're welcome & thanks for the feedback

 

[jamesmev]

.

 

[RoryA]

Then the cell doesn't match either of your text values.