Not sure where to turn for this information.

[RB]

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,

 

[T. Valko]

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.

 

[Max]

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

 

[Pete_UK]

And I think Max meant:

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

Hope this helps.

Pete

 

[Max]

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
---
And I think Max meant:

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

Hope this helps.

Pete

 

[Suleman Peerzade]

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

 

[T. Valko]

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!