Table Sorting and Pulldown Selections

apc3usa

New Member
Joined
Nov 11, 2005
Messages
2
I have a Frequency Band, Channel, and frequency list. The users pull down a list of Frequency bands, then in another cell select the channel, and the coresponding frequency appears in in the 3rd cell, but i cannot figure out how to accomplish this. Any help would be greatly appreciated.

band...channel... frequency
1............1.........1234
1............2.........1235
1............3.........1236

2 ............1.........2234
2 ............2.........2235
2 ............3.........2236

3............1.........3234
3............2.........3234
3............3.........3234
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
search the board for 'multi key lookup' - post back if you can't get something to work.
 
Upvote 0
apc3usa

Welcome to the Mr Excel board!

Is this what you mean? The pull down lists for band and channel are in E2 and F2 respectively. The formula in G2 is:
=SUMPRODUCT(--(A2:A12=E2),--(B2:B12=F2),C2:C12)
Mr Excel.xls
ABCDEFG
1bandchannelfrequencybandchannelfrequency
2111234232236
3121235
4131236
5
6212234
7222235
8232236
9
10313234
11323234
12333234
13
Pulldown Selections
 
Upvote 0

Forum statistics

Threads
1,214,770
Messages
6,121,442
Members
449,033
Latest member
Kcolwell16

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top