Not sure where to turn for this information.
 

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,

Not sure where to turn for this information.
 

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,

Not sure where to turn for this information.
 

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
---

Not sure where to turn for this information.
 

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
---

Not sure where to turn for this information.
 

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

Not sure where to turn for this information.
 

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,

Not sure where to turn for this information.
 

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