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.
Bookmarks