Hi there,
got a question regarding an If formula which is confusing me.
I want to say if the value in cell a9 appears in the range b:b (on a different tab) return the corrosponding value in column s and divide this value by a the value in cell J9. if not ""
hope that makes sense
got a question regarding an If formula which is confusing me.
I want to say if the value in cell a9 appears in the range b:b (on a different tab) return the corrosponding value in column s and divide this value by a the value in cell J9. if not ""
hope that makes sense