Forum Discussion
IF Function
Hi I am trying to set up a document, that uses ifs function. It should look in a cell and write the number, if there is any. If there isn't any it should look in another cell and so on. I ha...
If the 5 cells from which to look into are in A1:E1 and your formula cell is F1, the formula therein is:
=INDEX(A1:E1,
MATCH(1,
INDEX(—ISNUMBER(A1:E1),0),
1))
=INDEX(A1:E1,
MATCH(1,
INDEX(—ISNUMBER(A1:E1),0),
1))