Find A Value In Sheet?

B

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?? :confused:
 
S

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.

|
| 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?? :confused:
|
|
| --
| BL69
| ------------------------------------------------------------------------
| BL69's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=24241
| View this thread: http://www.excelforum.com/showthread.php?threadid=378507
|
 
Top