Cross-Referencing Multiple Spreadsheets

**vlsbnapa** · 03-06-2013, 05:05 PM

I have a workbook with two spreadsheets. One contains customer information. The other line items and shipping information. I would like to pull the customer number over to the line items spreadsheet. Both spreadsheets have the order number, but note there is a new line for every item in an order on the line items sheet.
How do I accomplish this?

**Gretta Wilson** · 03-06-2013, 05:12 PM

could you attach a sample?

**vlsbnapa** · 03-06-2013, 07:09 PM

I answered my own question: =VLOOKUP(A2,Orders!$A$2:$B$5,2,FALSE) seems to work in my example. Inserted a column next to the order number and added the function there. Caveat: Spreadsheets must be sorted.