How do I VLookup visible cells only?
Can you post some sample and tell us what you're wanting to lookup and what
result you expect?
--
Biff
Microsoft Excel MVP
"DC777" wrote in message
...
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?
|