Reference another Excel sheet using a cells value - Super User

Yes, clarification required. If B1 first matches Sheet1!AY100, for instance, then MATCH returns 99, which cell value do you want the formula to return in that case? - which version of excel are you using? – barry houdini Oct 9 '12 at 20:44

superuser.com