I have a Sheet with price list contains three columns. First is IDCode
for particular item, second is item title and third column is price of
item.
I would like to make another sheet in which I could make an order based
on mentioned price list and every time I enter code of item in order
list it should be connected to Sheet with price list and get price from
third column that coresponds to item code i have entered into order
list?
I know that there are many easier ways to accomplish this without using
Excel but is there any way to do it with Excel??


--
BL69
------------------------------------------------------------------------
BL69's Profile: http://www.excelforum.com/member.php...o&userid=24241
View this thread: http://www.excelforum.com/showthread...hreadid=378507

use VLOOKUP function. Check excel's help on how to use it.

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=378507

You can look he http://www.contextures.com/xlFunctions02.html#Simple

--
Summer (no valid email)
Thought ~
If you stop to kick at every dog that barks at you, you'll never get very
far.

"BL69" wrote in message
...
|
| I have a Sheet with price list contains three columns. First is IDCode
| for particular item, second is item title and third column is price of
| item.
| I would like to make another sheet in which I could make an order based
| on mentioned price list and every time I enter code of item in order
| list it should be connected to Sheet with price list and get price from
| third column that coresponds to item code i have entered into order
| list?
| I know that there are many easier ways to accomplish this without using
| Excel but is there any way to do it with Excel??
|
|
| --
| BL69
| ------------------------------------------------------------------------
| BL69's Profile:
http://www.excelforum.com/member.php...o&userid=24241
| View this thread: http://www.excelforum.com/showthread...hreadid=378507
|