Will VLOOKUP help here?

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

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
 
T

Toppers

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
 
J

Jason

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

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
 

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

vlookup & wildcards 3
link worksheet A & B 0
Help in Excel creating Formula's 0
Vlookup Help 2
VLOOKUP & Data Validation 0
Match and Vlookup issue 2
VLOOKUP formula 3
inserting hyperlink 1

Top