Good morning. I'm trying to do a lookup with a single criteria across multiple sheets with very little success. I tried using INDEX and INDIRECT but came up short. It's only one criteria that is based on a data validation drop down, which I've highlighted on a Summary tab. I've attached the sample file. Any help would be appreciated!
So if you select A5, do you simply want to see what is on sheet A5... or something else. If so, what? You didn't specify...
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
If that's what you want, in summary B6, copied across and down:
=INDIRECT("'"&$A$2&"'!"&ADDRESS(ROWS($1:4)+2,COLUMNS($A:A)+1,4))
This what your wanting? Enter in B6 Drag across and down
Formula:
Please Login or Register to view this content.
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks