Will VLOOKUP help here?

[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!

 

[Pete_UK]

The third parameter of the VLOOKUP function specifies which column to
retrieve data from when a match is found. In your case you have this
as 1, whereas you want data to come from column I, so set it to 9.

Also, if you are copying the formula down a column, you would need to
make the cell references for the table into absolute. So, your formula
should become:

=VLOOKUP(A1,WorksheetA!$A$1:$I$400,9,FALSE)

You can also use 0 instead of FALSE (less typing !).

Hope this helps.

Pete

 

[Guest]

Minor change:

=VLOOKUP(A1,WorksheetA!A1:I400,9,FALSE)

9 reflects the fact that you want the value from the 9th column (I) of your
range.

HTH

 

[Jason]

Thanks for your help! I've got it working now. This is much better than
coding macros.

 

[Pete_UK]

Thanks for feeding back. Certainly, you should use formulae if you
can, but there are some things you can only do with a macro.

Pete