Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I VLookup visible cells only?
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I VLookup visible cells only?
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: http://www.freefilehosting.net/download/3ijm5 Filter over lines by key col in another sht.xls -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "DC777" wrote: 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sum visible cells | Excel Discussion (Misc queries) | |||
Sum Visible Cells | Excel Worksheet Functions | |||
Sum of visible cells only | Excel Worksheet Functions | |||
Vlookup Against Value In First Visible Cell | Excel Discussion (Misc queries) | |||
Visible Cells Only! | Excel Worksheet Functions |