Get data from another worksheet in same workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a workbook that has sheets for each days orders with some brief
information about each order. The first sheet "Tracking" has 2 columns
"ORDER" and "TRACK". They contain an order number and a tracking number for
that order.

I want set a cell for each order in each of the daily sheets to search the
first sheet for the order number. If the order number is found display the
corresponding tracking number. If possible I would like to to display Not
Shipped if the order number cannot be found in the first sheet.

I am not sure how to even go about doing this. I can provide an sample
workbook if it will help clarify what I am trying to explain.
 
Sounds like you are just wanting to do a Vlookup, assuming the Order number
is in Cell A1 on the subsequent sheets, Order is in A1 on the 1st sheet and
Track is in B1 then something like this.

=VLOOKUP(A1,Tracking!A1:B232,2,FALSE)

put this where you want the tracking number to show up.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell values to an array, then array transpose to another workbook 8
couple subs I need help with 1
[Q] How to sort tabs in order of CodeName 2
trying to find solution to copy duplicated data from one sheet to 12
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Worksheet Sort Order 2
copy sheets 2
Sharing workbook removes cell protection 1

Back
Top