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
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