J
Jason
I'm hoping there's a simple formula to address my needs here (I'm an Excel
newbie).
WorksheetA contains nine columns including order numbers (A1) and tracking
numbers (I1). WorksheetB contains only order numbers (A1) and a column I
paste tracking numbers into. We are currently manually copying and pasting
the tracking numbers from WorksheetA into WorksheetB, which is quite a hunt
and peck hassle that must be done as WorksheetB contains specific orders we
need to track. Is there a formula I can put into WorksheetB that will find
the corresponding order number on WorksheetA, then grab the tracking number
that is on the same row, and drop that into WorksheetA? I thought VLOOKUP
would do this. I've tried
VLOOKUP(A1,WorksheetA!A1:I400,1,FALSE)
....without success. Is this possible with a formula or should I ask in the
programming group? Thanks!
newbie).
WorksheetA contains nine columns including order numbers (A1) and tracking
numbers (I1). WorksheetB contains only order numbers (A1) and a column I
paste tracking numbers into. We are currently manually copying and pasting
the tracking numbers from WorksheetA into WorksheetB, which is quite a hunt
and peck hassle that must be done as WorksheetB contains specific orders we
need to track. Is there a formula I can put into WorksheetB that will find
the corresponding order number on WorksheetA, then grab the tracking number
that is on the same row, and drop that into WorksheetA? I thought VLOOKUP
would do this. I've tried
VLOOKUP(A1,WorksheetA!A1:I400,1,FALSE)
....without success. Is this possible with a formula or should I ask in the
programming group? Thanks!