If True Formula

[ronie85]

I am looking 2 formulas. Cell R5 contains data and cell R15 tells me if this data is true. I therefore want cell R16 to check if Cell R15 is True and therefore show the data that is contained within cell R12. If Cell R15 is false I don't want cell R16 to show anything. The 2nd formula I am looking is this and it ties in with the details above. Column R is the newest column with S, T, U, V ect showing data. basically the older to newest goes from right to left rather than the other way. I need a formula in say cell A16 to show the text in the closest cell within this row. In this case being R16. Next week it will show Q16, then P16 and so on. I just wasn't this formula to update on a weekly basis when the new entries have been put in.

 

[FormR]

Hi, maybe in R16:
=IF(R15,R12,"")

and in A16
=INDEX(B16:V16,MATCH(TRUE,(INDEX(B16:V16<>"",0)),0))

You may need to alter the columns.. I have assumed your data starts in column V and ends in column B

 

[ronie85]

Hi, maybe in R16:
=IF(R15,R12,"")

and in A16
=INDEX(B16:V16,MATCH(TRUE,(INDEX(B16:V16<>"",0)),0))

You may need to alter the columns.. I have assumed your data starts in column V and ends in column B

That worked a treat!! Thank you very much, now I need to implement it 3 times across 92 sheets lol, Thanks again