Auto Filter cells that are populated with vlookup

[bearclaw]

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

[abousetta]

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

[bearclaw]

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

[abousetta]

Since you are using Excel 2010 then I would cushion the vlookup with an IFERROR statement. Something like:

Please Login or Register  to view this content.

Hope this helps.

abousetta

[bearclaw]

Works great! Thanks for the tip.

[abousetta]

Glad it all worked out. If you are satisfied with the response then please mark the thread as Solved.

Good luck.

abousetta