# Table Sorting and Pulldown Selections

#### apc3usa

##### New Member
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.

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

Replies
3
Views
388
Replies
109
Views
5K
Replies
4
Views
305
Replies
3
Views
381
Replies
1
Views
344

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.

### Which adblocker are you using?

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

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