Table Sorting and Pulldown Selections

[apc3usa]

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

 

[PaddyD]

search the board for 'multi key lookup' - post back if you can't get something to work.

 

[Peter_SSs]

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
	A	B	C	D	E	F	G
1	band	channel	frequency		band	channel	frequency
2	1	1	1234		2	3	2236
3	1	2	1235
4	1	3	1236
5
6	2	1	2234
7	2	2	2235
8	2	3	2236
9
10	3	1	3234
11	3	2	3234
12	3	3	3234
13
Pulldown Selections