Vlookup multipe criteria and 2 sheets

February 23, 2012 at 11:57:05
Specs: Windows XP
I have an excel file with two sheets. Sheet 1 contains a master invoice from a vendor with client names in one column and the item ordered in another. Sheet 2 contains our list of clients and items ordered. I want to match up the two via vlookup and see what we were invoiced for that we don't show on sheet 2. so I have to match up client names and item numbers. I may show a client on sheet 1 seven times with a bunch of different or even duplicate item numbers. But I may only show that client three times on sheet two with only some of the same item numbers as on Sheet 1. Any suggestions on how to solve this?

See More: Vlookup multipe criteria and 2 sheets

Report •

February 23, 2012 at 12:25:57
Have you tried using Advanced Filter with Criteria?

Look it up in the Help files and do some Google searches for examples.

Perhaps that will get you the results that you are looking for.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question