looking for solution

  • Thread starter Thread starter rusty_jones
  • Start date Start date
R

rusty_jones

I tried to figure out how to customize column B and column C of this
formula to return custom messages if each column returns a false entry.

{=INDEX(S1!$D$2:$D$7932,MATCH(1,((S1!$A$2:$A$7932=$B14)*(S1!$B$2:$B$7932=$C14)*(S1!$C$2:$C$7932=$E14)),0))}

Im still a beginner and I unsure as to what function to use.

Any help would be appreciated.

Rusty
 
If I understood correctly, you want to return a custom message if there isn't a
match for all 3 columns.

Maybe:

=if(iserror(match(justthematchportionofyourformula)),"your custom message",
index(thatwholeexistingformula))
 
Back
Top