INDIRECT Query: How to incorporate INDIRECT to choose between two ranges?

Originally Posted by The_Snook

Eisayew is in the right ball park for what i'm trying to achieve but unfortunately i'm getting an error message when I try to copy and paste it?!?!

Any suggestions?

Try to replace semicolons ";" with commas