| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
VLOOKUP Question for New User
I have a list of 800 items I must look up from one worksheet and enter the
price on another worksheet. The worksheets are not similar. Using a common item number that appears in both worksheets, will VLOOKUP do this for me? In other words copy a price from one worksheet to the proper column in another worksheet? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
VLOOKUP Question for New User
Let's say that your common item numbers are both in column A
=VLOOKUP(A2,OtherSheet!A:H,8,False) will pull the data from column H of the OtherSheet. If you actually have a separate workbook, then the formula will be slightly different, but not significantly. HTH, Bernie MS Excel MVP "vburns" wrote in message ... I have a list of 800 items I must look up from one worksheet and enter the price on another worksheet. The worksheets are not similar. Using a common item number that appears in both worksheets, will VLOOKUP do this for me? In other words copy a price from one worksheet to the proper column in another worksheet? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
VLOOKUP Question for New User
Does this mean I still have to type in the item number each time in cell A2
to return the price from the other worksheet? "Bernie Deitrick" wrote: Let's say that your common item numbers are both in column A =VLOOKUP(A2,OtherSheet!A:H,8,False) will pull the data from column H of the OtherSheet. If you actually have a separate workbook, then the formula will be slightly different, but not significantly. HTH, Bernie MS Excel MVP "vburns" wrote in message ... I have a list of 800 items I must look up from one worksheet and enter the price on another worksheet. The worksheets are not similar. Using a common item number that appears in both worksheets, will VLOOKUP do this for me? In other words copy a price from one worksheet to the proper column in another worksheet? |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
VLOOKUP Question for New User
Yes
Perhaps a Data Validation Dropdown list in A2 would help? See Debra Dalgleish's site for help on Data Validation lists. http://www.contextures.on.ca/xlDataVal01.html Gord Dibben MS Excel MVP On Tue, 19 Aug 2008 12:15:01 -0700, vburns wrote: Does this mean I still have to type in the item number each time in cell A2 to return the price from the other worksheet? "Bernie Deitrick" wrote: Let's say that your common item numbers are both in column A =VLOOKUP(A2,OtherSheet!A:H,8,False) will pull the data from column H of the OtherSheet. If you actually have a separate workbook, then the formula will be slightly different, but not significantly. HTH, Bernie MS Excel MVP "vburns" wrote in message ... I have a list of 800 items I must look up from one worksheet and enter the price on another worksheet. The worksheets are not similar. Using a common item number that appears in both worksheets, will VLOOKUP do this for me? In other words copy a price from one worksheet to the proper column in another worksheet? |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
VLOOKUP Question for New User
Too hasty with the first post.
If your list of items is in a range of say, A2:A800, simply enter Bernie's formula in B2 then copy down to B800 by double-click on the fill handle of B2. Gord On Tue, 19 Aug 2008 12:15:01 -0700, vburns wrote: Does this mean I still have to type in the item number each time in cell A2 to return the price from the other worksheet? "Bernie Deitrick" wrote: Let's say that your common item numbers are both in column A =VLOOKUP(A2,OtherSheet!A:H,8,False) will pull the data from column H of the OtherSheet. If you actually have a separate workbook, then the formula will be slightly different, but not significantly. HTH, Bernie MS Excel MVP "vburns" wrote in message ... I have a list of 800 items I must look up from one worksheet and enter the price on another worksheet. The worksheets are not similar. Using a common item number that appears in both worksheets, will VLOOKUP do this for me? In other words copy a price from one worksheet to the proper column in another worksheet? |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
VLOOKUP Question for New User
Thank you for your help. I'm determined to make this work, but I can't yet
get it to work. My common item numbers are in column F in both worksheets. I want my price returned from column G in the other price list to column P of my worksheet. This is my formula: =VLOOKUP(F7:F651,'08pricelist'!F:G,7,FALSE) Can you tell what I've done wrong? I get the #REF! error. "Gord Dibben" wrote: Too hasty with the first post. If your list of items is in a range of say, A2:A800, simply enter Bernie's formula in B2 then copy down to B800 by double-click on the fill handle of B2. Gord On Tue, 19 Aug 2008 12:15:01 -0700, vburns wrote: Does this mean I still have to type in the item number each time in cell A2 to return the price from the other worksheet? "Bernie Deitrick" wrote: Let's say that your common item numbers are both in column A =VLOOKUP(A2,OtherSheet!A:H,8,False) will pull the data from column H of the OtherSheet. If you actually have a separate workbook, then the formula will be slightly different, but not significantly. HTH, Bernie MS Excel MVP "vburns" wrote in message ... I have a list of 800 items I must look up from one worksheet and enter the price on another worksheet. The worksheets are not similar. Using a common item number that appears in both worksheets, will VLOOKUP do this for me? In other words copy a price from one worksheet to the proper column in another worksheet? |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
VLOOKUP Question for New User
In P7, enter the formula:
=VLOOKUP(F7,'08pricelist'!F:G,2,FALSE) and copy down as far as your need. HTH, Bernie MS Excel MVP "vburns" wrote in message ... Thank you for your help. I'm determined to make this work, but I can't yet get it to work. My common item numbers are in column F in both worksheets. I want my price returned from column G in the other price list to column P of my worksheet. This is my formula: =VLOOKUP(F7:F651,'08pricelist'!F:G,7,FALSE) Can you tell what I've done wrong? I get the #REF! error. "Gord Dibben" wrote: Too hasty with the first post. If your list of items is in a range of say, A2:A800, simply enter Bernie's formula in B2 then copy down to B800 by double-click on the fill handle of B2. Gord On Tue, 19 Aug 2008 12:15:01 -0700, vburns wrote: Does this mean I still have to type in the item number each time in cell A2 to return the price from the other worksheet? "Bernie Deitrick" wrote: Let's say that your common item numbers are both in column A =VLOOKUP(A2,OtherSheet!A:H,8,False) will pull the data from column H of the OtherSheet. If you actually have a separate workbook, then the formula will be slightly different, but not significantly. HTH, Bernie MS Excel MVP "vburns" wrote in message ... I have a list of 800 items I must look up from one worksheet and enter the price on another worksheet. The worksheets are not similar. Using a common item number that appears in both worksheets, will VLOOKUP do this for me? In other words copy a price from one worksheet to the proper column in another worksheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| User Form question | Excel Discussion (Misc queries) | |||
| New user with a question | Excel Worksheet Functions | |||
| New User Question | New Users to Excel | |||
| user input question | Excel Discussion (Misc queries) | |||
|
< |
Excel Worksheet Functions | |||
Hybrid Mode
