Hi all,
I have vlookups populated my cells and I'm trying to use the filter function, top 10 for example but the filter does not work. Is there a way to work around so the filter will work on cells with vlookup?
Thanks
Matthew
Last edited by bearclaw; 12-09-2011 at 11:23 AM.
Hi Matthew,
Hello and welcome to the forum. Sorry, but I can't reproduce your problem. I just created a table and used vlookup on it and added the filter. Everythign is working just fine (sort, top 10, filter, sort by color, etc.). Could you upload a dummy copy of your worksheet that is causing the problem? If not, could you provide us with the exact forumula that you are using (this being a second, but leass prefereable option).
abousetta
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
Hello Abousetta,
Thanks for the quick feedback. I think I found the error. When there is a #N/A for a cell the auto filter will not work. Is there a solution for this as I don't want to remove the cells with #N/A because they populate based upon the data changing daily.
thanks
Matthew
Since you are using Excel 2010 then I would cushion the vlookup with an IFERROR statement. Something like:
Hope this helps.=IFERROR(VLOOKUP(A2,B2:G5,2,0),"")
abousetta
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
Works great! Thanks for the tip.
Glad it all worked out. If you are satisfied with the response then please mark the thread as Solved.
Good luck.
abousetta
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks