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?