SOLVED

Excel Formula Help Please

Copper Contributor

Hi Community

Hopefully you guys can give me a formula for the following - basically I have four cells, lets say A,B,C,D  (starting on column 2) - if I place an x in one of those cells I want the value to pop up in cell E.

The values are simple A=1 , B=2, C-3, D=4 - for example if i place an x in cell D - the number 4 will pop up in cell E - cell A,B and C will have nothing in their cells. Or if I place an x in cell A only and leave the other three blank a 1 will pop up in cell E and so on. Not sure if this is an "argument" or "if" function etc.

 

I hope thats not to confusing but I am sure its a simple formula for someone in the know - Many Thanks.

 

2 Replies
best response confirmed by Gwads1968 (Copper Contributor)
Solution

Hi,

 

I think the easiest solution is this formula:

=MATCH("x",A1:D1,0)

Simple Usage of MATCH.png

 

Hope that helps 

Amazing - It absolutely works, thank you so much.
1 best response

Accepted Solutions
best response confirmed by Gwads1968 (Copper Contributor)
Solution

Hi,

 

I think the easiest solution is this formula:

=MATCH("x",A1:D1,0)

Simple Usage of MATCH.png

 

Hope that helps 

View solution in original post