Find A Value In Sheet?

[BL69]

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??

[mangesh_yadav]

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

Mangesh

[Summer]

You can look here: 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" <BL69.1qkdaa_1118664302.6637@excelforum-nospam.com> wrote in message
news:BL69.1qkdaa_1118664302.6637@excelforum-nospam.com...
|
| 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
|