I have two spreadsheets of a customer's list of store locations.  I need to create shipping labels of 3500 stores, which are represented on Spreadsheet 'A', each on a separate row that includes full address -- street, city, ST, zip -- that I need along with the STORE NUMBER code, a 3 or 4 digit number.

The other spreadsheet 'B' contains the same list of store locations but without the shipping address. It contains only the store number code and a sales ranking value.  My client is asking me to ship my product in an order of prioritization according to sales rank; highest volume stores get shipped first as product comes off assembly line, lowest vol stores get shipped last.  Spreadsheet B contains abut 300 additional store numbers -- rows of data-- that are not on the Spreadsheet B, and I want to ignore those since I don't have shipping addresses for them.

How do I merge the sales rank value from spreadsheet B into the spreadsheet A, using the common denominator of the store number code?  Do I use a function formula?

Thanks, Tom
 

---

Answer from Richard Rost:

You can use the VLOOKUP function to get the store rank from sheet B into sheet A based on your store number. Then you can sort or perform whatever other analysis you need to on that one sheet.

You can use the VLOOKUP or HLOOKUP function.

VLOOKUP is a powerful function in Microsoft Excel that allows you to look up a value from another spreadsheet - or a smaller subtable (lookup table).

See this FREE tutorial for help with VLOOKUP:

http://599cd.com/tips/excel/vlookup/?key=BlFAlEx