Feb 14 2019 08:50 AM
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.
Feb 14 2019 09:09 AM
SolutionHi,
I think the easiest solution is this formula:
=MATCH("x",A1:D1,0)
Hope that helps
Feb 14 2019 09:49 AM
Feb 14 2019 09:09 AM
SolutionHi,
I think the easiest solution is this formula:
=MATCH("x",A1:D1,0)
Hope that helps