I have two spreadsheets with order information on one and ups tracking
information on the other.

Both sheets have the order #

On my report sheet I have a list of order #'s subtotaled. I need to pull in
the tracking info from the ups tracking sheet.

Currently I use a collapsed version of the subtotaled sheet and copy a
vlookup function to visible cells only.

However each order # could match multiple tracking #'s. I would like to
know if there is a way to search for the order # on a specific line in the
tracking sheet and return each unique match for the tracking #, in the next
cell I would like the Tracking Status and in the next cell the signature info.

My tracking sheet has 4 columns

Order #, Tracking #,Status,Signature

My order sheet has many columns but collapsed I would see order #, Sale
Total,Tracking#,Status,Signature. In a single row. I would like to populate
the cell for tracking #,Status,Signature with each unique value for that
order located in the tracking sheet.

Any help would be greatly appreciated.

Thanks

No.

An order # is treated as a shipment by ups. A shipment can have multiple
tracking #'s but those Tracking #'s would each be unique.

"Jim Thomlinson" wrote:

One order can have many tracking numbers. Can one tracking number possibly be
attached to multiple orders. If so this gets tricky...


"Michael" wrote:

I have two spreadsheets with order information on one and ups tracking
information on the other.

Both sheets have the order #

On my report sheet I have a list of order #'s subtotaled. I need to pull in
the tracking info from the ups tracking sheet.

Currently I use a collapsed version of the subtotaled sheet and copy a
vlookup function to visible cells only.

However each order # could match multiple tracking #'s. I would like to
know if there is a way to search for the order # on a specific line in the
tracking sheet and return each unique match for the tracking #, in the next
cell I would like the Tracking Status and in the next cell the signature info.

My tracking sheet has 4 columns

Order #, Tracking #,Status,Signature

My order sheet has many columns but collapsed I would see order #, Sale
Total,Tracking#,Status,Signature. In a single row. I would like to populate
the cell for tracking #,Status,Signature with each unique value for that
order located in the tracking sheet.

Any help would be greatly appreciated.

Thanks