relation between 'items' en 'prices'
 

Hello,
I am trying to make a Quote-spreadsheet. I have a column with items that i
can choose from a list. Now I want anothor column to get automaticly the
right price for that item out of a list. Do I need a formula that says if the
item in cel 'a' is 'x' than the price in cel 'b' is 'y' ? I am new and don't
now how to solve this. Can anybody help me.
Thanks in advance !

relation between 'items' en 'prices'
 

See this:

http://contextures.com/xlFunctions02.html

--
Biff
Microsoft Excel MVP


"Farid" wrote in message
...
Hello,
I am trying to make a Quote-spreadsheet. I have a column with items that i
can choose from a list. Now I want anothor column to get automaticly the
right price for that item out of a list. Do I need a formula that says if
the
item in cel 'a' is 'x' than the price in cel 'b' is 'y' ? I am new and
don't
now how to solve this. Can anybody help me.
Thanks in advance !

relation between 'items' en 'prices'
 

Thanks a lot ! It was quite difficult but I managed to resolve my problem.


"T. Valko" wrote:

See this:

http://contextures.com/xlFunctions02.html

--
Biff
Microsoft Excel MVP


"Farid" wrote in message
...
Hello,
I am trying to make a Quote-spreadsheet. I have a column with items that i
can choose from a list. Now I want anothor column to get automaticly the
right price for that item out of a list. Do I need a formula that says if
the
item in cel 'a' is 'x' than the price in cel 'b' is 'y' ? I am new and
don't
now how to solve this. Can anybody help me.
Thanks in advance !