Tuning my IF

[americanpie3]

=IF(A2=sheet2!A22,sheet2!z22,IF(A2=sheet2!A23,sheet2!z23,IF(a2=sheet2!A24,sheet2!z24)))

Telling me that the formula is invalid.

Thanks

 

[MrKowz]

Try:

=INDEX(Sheet2!Z22:Z24,MATCH(A2,Sheet2!A22:A24,0))

 

[Aladin Akyurek]

=IF(A2=sheet2!A22,sheet2!z22,IF(A2=sheet2!A23,sheet2!z23,IF(a2=sheet2!A24,sheet2!z24)))

Telling me that the formula is invalid.

Thanks

That shoud work. This too:

=INDEX(Sheet2!Z22:Z24,MATCH(A2,Sheet2!A22:A24,0))

which is equivalent.

 

[americanpie3]

Thank you gentlement. Works better and simpler and I like simpler.