| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Next to
This is a easy question. I am using Excel 2003. I have worksheet 1 (ws 1)
with a drop down list in column b validated from ws 2. I would like to have a formula in column c that matches the info to the validated ws and puts the info in the cell next to it in column c of ws 1. Thanks Josh |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell Next to
=VLOOKUP(A1,ws2!A:B,2,FALSE)
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Josh" wrote in message ... This is a easy question. I am using Excel 2003. I have worksheet 1 (ws 1) with a drop down list in column b validated from ws 2. I would like to have a formula in column c that matches the info to the validated ws and puts the info in the cell next to it in column c of ws 1. Thanks Josh |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell Next to
=VLOOKUP(B1,ws2!A1:B100,2,FALSE)
"Josh" skrev: This is a easy question. I am using Excel 2003. I have worksheet 1 (ws 1) with a drop down list in column b validated from ws 2. I would like to have a formula in column c that matches the info to the validated ws and puts the info in the cell next to it in column c of ws 1. Thanks Josh |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I copy a value from a cell and paste it into another cell while adding it to the previous value in that cell | Excel Worksheet Functions | |||
| Inputting cell value from source cell based on value in adjacent cell. | Excel Discussion (Misc queries) | |||
| How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Linear Mode
