Can you filter Excel by multiple values?
Often you may want to filter a column by multiple values in Excel. Fortunately this is easy to do using the Advanced Filter function.
Can I VLOOKUP multiple values?
An immediate solution that comes to mind is using the Excel VLOOKUP function, but the problem is that it can only return a single match. Vlookup for multiple values can be done via a combined use of several functions.