| Home |
| Search |
| Today's Posts |
|
#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? |
| 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 | |||
Threaded Mode
