complex if formula

[PGD15]

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

 

[Jonmo1]

Try

=IFERROR(INDEX('different tab'!$S:$S,MATCH(A9,'different tab'!$B:$B,0))/J9,"")

 

[PGD15]

Thanks, works brilliantly!

 

[Jonmo1]

You're welcome.