Check 4 cells for a value (EASY)

[rexy69]

hi, i reckon this is very easy to do, but i dont know what im doing

e.g

i have 5 cells a1, a2, a3, a4, a5

i will be putting a yes in either a1, a2, a3 or a4 manually

if i do put a yes in one of these i want A5 to work out which cell i put the yes into and then to do something different

e.g if yes is in A1 add 10
if yes is in A2 add 20
if yes is in A3 add 30
if yes is in A4 add 40

hope this makes sense

Thanks

[Tony Valko]

Maybe this...

=IFERROR(MATCH("yes",A1:A4,0)*10,"")

[rexy69]

worked perfectly

Many Thanks :D

[Tony Valko]

You're welcome. Thanks for the feedback!


If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.