Return fixed value if one of several variables matches the values in a row

[csinirli]

Hi,

I am trying to create a formula that will allow me to look up three numbers in a row and if those numbers match the value in the row, then return a fixed value.


Values that need to be looked up: 1, 3, 5

Row 1: containing numbers from 1 to 10

Value in Row 2 (in same column), if any values that need to be looked up matches the value in row 1: 50

So if done correctly, in row 2, in columns 1, 3 and 5, I should have the value 50.

Please let me know if I need to clarify further - I realize that was probably a terrible description.

Any help would be much appreciated!

Thanks,

Cem

 

[Aladin Akyurek]

Looks like...

A1:J1 houses numbers from 1 to 10

In A2 enter and copy across:

=IF(ISNUMBER(MATCH(A1,{1,3,5},0)),50,"")

Does this help?