I have a worksheet that I am making, and I have put drop down tables in it.
Now lets say I select Apples from the drop down menu, I want it to display
the price for the apples in the next colum, and if I choose Oranges, the
price for oranges, and so on. I am racking my brain on how to do this, and I
really don't know how to look it up. Any help that anyone could give would
be great.

Thanks,

Create a 2 column table with the product in the left column and the price in
the right column:

...........A..........B
1....Apples....1.99
2....Grapes....1.49
3....Dates......2.99
4....Figs........7.69

Assume your drop down list is in cell D1:

D1 = Grapes

Entered in cell E1:

=SUMIF(A1:A4,E1,B1:B4)

As an added bonus, you can use the left column of the table as the source
for your drop down list.

--
Biff
Microsoft Excel MVP


"RB" wrote in message
...
I have a worksheet that I am making, and I have put drop down tables in it.
Now lets say I select Apples from the drop down menu, I want it to display
the price for the apples in the next colum, and if I choose Oranges, the
price for oranges, and so on. I am racking my brain on how to do this,
and I
really don't know how to look it up. Any help that anyone could give
would
be great.

Thanks,

Believe Biff meant, in E1: =SUMIF(A1:A4,D1,B1:B4)

Another usual way is via a vlookup:
In E1: =IF(E1="","",VLOOKUP(D1,$A$1:$B$4,2,0))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---

And I think Max meant:

In E1: =IF(D1="","",VLOOKUP(D1,$A$1:$B$4,2,0))

Hope this helps.

Pete

On Jan 23, 10:29*am, Max wrote:
Believe Biff meant, in E1: =SUMIF(A1:A4,D1,B1:B4)

Another usual way is via a vlookup:
In E1: =IF(E1="","",VLOOKUP(D1,$A$1:$B$4,2,0))
--
Max
Singaporehttp://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---

Yes, I did. Thanks for the correction.
(Like Biff, think I got warped into the "circular" vortex <g)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
"Pete_UK" wrote in message
...
And I think Max meant:

In E1: =IF(D1="","",VLOOKUP(D1,$A$1:$B$4,2,0))

Hope this helps.

Pete

Hi,

You can use lookup for this the vlook up formula would be something like
this. Since you already have a table this will help you.
=VLOOKUP(L1,I1:J3,2,FALSE)
--
_______________________
Click "Yes" if it helps
________
Thanks
Suleman Peerzade


"RB" wrote:

I have a worksheet that I am making, and I have put drop down tables in it.
Now lets say I select Apples from the drop down menu, I want it to display
the price for the apples in the next colum, and if I choose Oranges, the
price for oranges, and so on. I am racking my brain on how to do this, and I
really don't know how to look it up. Any help that anyone could give would
be great.

Thanks,

Like Biff, think I got warped into the "circular" vortex <g

We're all victims of the vortex at one time or another.

May the force be with you!

--
Biff
Microsoft Excel MVP


"Max" wrote in message
...
Yes, I did. Thanks for the correction.
(Like Biff, think I got warped into the "circular" vortex <g)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
"Pete_UK" wrote in message
...
And I think Max meant:

In E1: =IF(D1="","",VLOOKUP(D1,$A$1:$B$4,2,0))

Hope this helps.

Pete