I need a formula for this:
IF B7:D7 MATCHES M1, RETURN "6" , IF NO MATCH RETURN "X"
I need a formula for this:
IF B7:D7 MATCHES M1, RETURN "6" , IF NO MATCH RETURN "X"
Last edited by Jordans121; 03-07-2010 at 10:02 PM.
Please use this adjusted attachment
What is wrong with this formula?
=if(match(m1,b7:d7,0),[6],[x])
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks