Forum Discussion

Gwads1968

Copper Contributor

Feb 14, 2019

Solved

Excel Formula Help Please

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 val...

excel

Formulas and Functions

Haytham Amairah
Feb 14, 2019
Hi,

I think the easiest solution is this formula:
=MATCH("x",A1:D1,0)

Hope that helps
Simple Usage of MATCH.xlsx9 KB

Haytham Amairah

Silver Contributor

Feb 14, 2019

Hi,

I think the easiest solution is this formula:

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

Hope that helps

Simple Usage of MATCH.xlsx9 KB

Gwads1968

Copper Contributor

Feb 14, 2019

Amazing - It absolutely works, thank you so much.