Vlookup

ezteze

Board Regular
Joined
Apr 24, 2013
Messages
66
hello all,
so i have a few excel sheets that have information on them. each excel sheet is an purchase order. in them it has all item information with sku cases QTY unit QTY and pricing and more. so i have a few excel sheets each one is a diffrent order for a diffrent factory. what i want to do is create an excel sheet that i can combine all the info from all sheet into one master file sheet. so what i want to do is a v look up to grab information from the individual excel sheets into my master one
 

Some videos you may like

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

CyrusTheVirus

Well-known Member
Joined
Jan 28, 2015
Messages
736
Office Version
365
Platform
Windows
Can you please provide an example so the viewers can see?

Perhaps use two sheets of data and one sheet of the master file showing your expected results.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,134
Messages
5,466,864
Members
406,506
Latest member
Patb3

This Week's Hot Topics

Top