Issue resolved in this posting:
http://www.microsoft.com/communities...3-d36569bbf735

Thanks!



"yhoy" wrote:

I have multiple tabs with same format. Is it possible to set up the vlookup
with tab name as an input?

example tab names: US1, US2, CA1

Thanks!