Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
How do I VLookup visible cells only?
411 views
Skip to first unread message
DC777
Jun 25, 2008, 1:53:02 PM6/25/08
to
I am trying to do a VLookup from one worksheet to another. When I Filter the
source worksheet and use the Vlookup function it reads both the filtered and
non-filtered cells. Instead of returning only the visible cells, it returns
values associated with both visible and hidden cells. How do I tell it to
give me only the Filtered values?
source worksheet and use the Vlookup function it reads both the filtered and
non-filtered cells. Instead of returning only the visible cells, it returns
values associated with both visible and hidden cells. How do I tell it to
give me only the Filtered values?
Max
Jun 25, 2008, 7:06:00 PM6/25/08
to
Not sure that's possible. I'd keep it cleaner by dynamically extracting the
filtered results into a new sheet, then point the vlookup to read that sheet.
If you're interested in that route, there's a simple, fast non-array play
illustrated in this recent sample (my response to another poster) which might
appeal to you:
filtered results into a new sheet, then point the vlookup to read that sheet.
If you're interested in that route, there's a simple, fast non-array play
illustrated in this recent sample (my response to another poster) which might
appeal to you:
http://www.freefilehosting.net/download/3ijm5
Filter over lines by key col in another sht.xls
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
T. Valko
Jun 25, 2008, 10:56:43 PM6/25/08
to
Can you post some sample and tell us what you're wanting to lookup and what
result you expect?
result you expect?
--
Biff
Microsoft Excel MVP
"DC777" <DC...@discussions.microsoft.com> wrote in message
news:F31620DD-4CEB-44B8...@microsoft.com...
0 new messages