If question

[bojan0810]

I have a question.

I need to make sheet that will calculate how many items needs to be at certain price.

I have list of items and I was thinking something with formula without macros.
List is like item and price.

First I need if that is possible is like:

If I put name in one cell that it will show price of that item.

Maybe something like this formula, for example A1 is cell for items to write.
List is on sheet 1 so I will write S1 for sheet 1.

If(A1=some item in S1 then B1=price of that item from S1)

Is this possible?

 

[Claus Busch]

Hi,

Am Thu, 31 Oct 2013 05:01:42 -0700 (PDT) schrieb (e-mail address removed):

If(A1=some item in S1 then B1=price of that item from S1)

your products in column S and the prices in column T
Then in B1:
=VLOOKUP(A1,$S$1:$T$100,2,0)



Regards
Claus B.

 

[bojan0810]

Maybe I didn't explain it right.

For make it simple.

list is like this
A column showing name B column showing price

so for example I have 5 items. So list is then A1-A5(name), B1-B5(price). So basically list is A1:B5

So for example if I write item name in C1 it will show price in D1

 

[bojan0810]

Nevermind you gave me answer and I didn't understand it right at first. Its ok now.

Thanks for quick reply and help.