showing multiple results with VLookup between two spreadsheets

[Holley]

Thanks again as always for all your past help! I come to you once again in hopes of resolving an Excel issue. I know it can be done… I just cannot figure it out. I have two spreadsheets. Spreadsheet 1 contains multiple PO#s in Col B (It does not provide me with the invoice #). Spreadsheet 2 contains invoice #s in col A and their corresponding PO # in Col B. What I am trying to figure out is how to use VLookup on Spreadsheet 1 to show me each occurrence of the invoice # that shares the same PO between the two spreadsheets. Maybe another formula would be better?

 

[smozgur]

GOT DATA! YAY!! You are a lifesafer and GENIUS! THANK YOU SO VERY MUCH!!

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.