Get data from another worksheet in same workbook
 

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.

Get data from another worksheet in same workbook
 

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.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"klassic" wrote:

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.