I am filtering a worksheet then using VLOOKUP() to return values. Problem I have is that the VLookup() is ignoring the filter condition. How should this formula be changed to only search visible (filtered) cells?
Please Login or Register to view this content.
Instead of VLookup, use the .Find method with the argument LookIn:=xlValues. That method\argument searches only visible cells.
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
That got it, thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks