Vlookup help!!!

grb23

New member
Joined
Apr 30, 2021
Messages
2
Reaction score
0
Points
0
Excel Version(s)
Office 365
HI All

I'm new to excel and am in desperate need of some help. I have two spreadsheets in the same workbook one has 241 rows the other has 6000+ rows. I need to extract and match data from the larger spreadsheet to the smaller spreadsheet

The are set up as:
Sheet 1 - Invoice, Quantity, Product Cost, Description, Date of Sale - This sheet has 6000+ rows
Sheet 2 - Invoice, Quantity, First Name, Last Name, Street, City, State, Zip - 241 Rows

I've tried using Vlookup but just can't get it right.

Any HELP would be really appreciated.

Thank You
 
What are you trying to bring from the larger spreadsheet into the smaller one?

Share a sample workbook with two tabs.
 
Thanks for looking at this. I'm trying to add the name and address information on Sheet 1 to the sales information on sheet 2. The idea being that at the end of the day I have one sheet containing all of the data. The issue I have is that in some cases the client identified on sheet 1 may have made multiple purchases, so I want to ensure I capture all of the transactions.

Thank You
 

Attachments

  • sample data1.xlsx
    10.3 KB · Views: 12
Back
Top