Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Will VLOOKUP help here?
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Will VLOOKUP help here?
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 On Mar 21, 7:54 pm, Jason wrote: 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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Will VLOOKUP help here?
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" wrote: 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! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Will VLOOKUP help here?
Thanks for your help! I've got it working now. This is much better than
coding macros. "Pete_UK" wrote in oups.com: 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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Will VLOOKUP help here?
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 On Mar 21, 11:13 pm, Jason wrote: Thanks for your help! I've got it working now. This is much better than coding macros. "Pete_UK" wrote groups.com: 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.- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
IF(a1="x",(vlookup 18K rows,2,false),(vlookup 18K,3,false)) RAM? | Excel Worksheet Functions | |||
IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |