Hello,

I've read through some of the posts to find an answer to my problem but
without much luck. Essentially, what I'm trying to do is create a calculator
that will help me determine pricing on some items. Below is an example of
the two source columns I'm interested in using:

Fruit Price
Apple $0.10
Orange $0.20
Pear $0.30

Now I've created a drop-down list - using data validation - in one cell from
which I can select a fruit. What I'd like is for Excel to return the value
of the fruit in the cell adjacent to my selection. So, for example, if I
select "Pear" I want $0.30 to appear in the cell immediately to the right of
my selection from the drop-down list.

To further complicate the issue, I'd like to be able to add a new value (in
this case price of fruit in $cents) and have Excel return what percent above
my initial price that is. So to continue the example from above, my end
result would look something like this:

Fruit Unit Price New Price Percent Above Unit Price
Pear $0.30 $0.40 133%


I think I'm supposed to use the VLOOKUP function on a pivot chart but am
still struggling with that.

Thanks for taking the time to read my post. I realize it's long, but I
wanted to be as clear about my problem as possible. Any help would be
greatly appreciated.

Thanks