I posted this a few days ago, but Don't think I explained myself very well. Can anybody help me with this issue. I am trying to select an item from a pick list (Cell A1) to be inserted into another cell and be able to automatically copy the adjacent cell (A2) value to another cell.


Example:

This is the pick list

Cell A1 Cell A2
PAPER HOLDER - LEVEL I (CHROME) $2.80
TOWEL BAR - 24" LEVEL I (CHROME) $2.80
TOWEL BAR - 18" LEVEL I (CHROME) $2.80


Once I choose the item from Cell A1 to fill in another cell location, I want the adjacent price in Cell A2 to automatically fill in another cell location as well.

Thank you, Dave & Max for your suggestions. Maybe you or some other experienced Excel geniouses can help me out.

Thanks,
Ty

Ty /
31 min. 25 sec. ago


Header
Report as Spam



---
frmsrcurl: http://msgroups.net/microsoft.public.excel.misc/

Why didn't you like the suggestions that you got the other day?

For others who may be posting, one of them suggested creating a table and using
data|validation and an =vlookup() formula.

And the other suggested using a formula to extract the monetary value from the
string in the picklist cell.

Ty wrote:

I posted this a few days ago, but Don't think I explained myself very well. Can anybody help me with this issue. I am trying to select an item from a pick list (Cell A1) to be inserted into another cell and be able to automatically copy the adjacent cell (A2) value to another cell.

Example:

This is the pick list

Cell A1 Cell A2
PAPER HOLDER - LEVEL I (CHROME) $2.80
TOWEL BAR - 24" LEVEL I (CHROME) $2.80
TOWEL BAR - 18" LEVEL I (CHROME) $2.80

Once I choose the item from Cell A1 to fill in another cell location, I want the adjacent price in Cell A2 to automatically fill in another cell location as well.

Thank you, Dave & Max for your suggestions. Maybe you or some other experienced Excel geniouses can help me out.

Thanks,
Ty

Ty /
31 min. 25 sec. ago

Header
Report as Spam

---
frmsrcurl: http://msgroups.net/microsoft.public.excel.misc/

--

Dave Peterson

Dave,

My dilemma is that I'm not experienced in creating tables or databases in excel. I'm struggling with the solutions. After I create my table, when I go to validation mode, it won't let me choose the sheet where I have the data in the table.

---
frmsrcurl: http://msgroups.net/microsoft.public...k-List-Problem

Name the source range on the other sheet using InsertNameDefine.

Then in DVListSource type in =MyName


Gord Dibben MS Excel MVP


On Sat, 13 Feb 2010 09:42:23 -0800, Ty / wrote:

Dave,

My dilemma is that I'm not experienced in creating tables or databases in excel. I'm struggling with the solutions. After I create my table, when I go to validation mode, it won't let me choose the sheet where I have the data in the table.

---
frmsrcurl: http://msgroups.net/microsoft.public...k-List-Problem

Did you read those links in the first thread?

There's lots of info in those.

Ty wrote:

Dave,

My dilemma is that I'm not experienced in creating tables or databases in excel. I'm struggling with the solutions. After I create my table, when I go to validation mode, it won't let me choose the sheet where I have the data in the table.

---
frmsrcurl: http://msgroups.net/microsoft.public...k-List-Problem

--

Dave Peterson

Dave,

I'm not experienced with creating tables in excel and naming ranges. I can't get the solutions to work for me. It would be nice if I could attach my spreadsheet so that the actual cell locations could be seen by those who may be able to help.

Ty

---
frmsrcurl: http://msgroups.net/microsoft.public...k-List-Problem

You can upload your workbook to one of these sites.

http://www.freefilehosting.net/
http://savefile.com/

After uploading, post the access URL you were given

Someone may have a look at it.



Gord Dibben MS Excel MVP

On Sat, 13 Feb 2010 09:53:17 -0800, tott1 / wrote:

Dave,

I'm not experienced with creating tables in excel and naming ranges. I can't get the solutions to work for me. It would be nice if I could attach my spreadsheet so that the actual cell locations could be seen by those who may be able to help.

Ty

---
frmsrcurl: http://msgroups.net/microsoft.public...k-List-Problem

Gord,

Both the 2 file host links mentioned are gone, they're just a distant memory
now
This oldie can still be used though:
http://cjoint.com/

--
Max
Singapore

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
You can upload your workbook to one of these sites.

http://www.freefilehosting.net/
http://savefile.com/

After uploading, post the access URL you were given

Someone may have a look at it.



Gord Dibben MS Excel MVP