value from other sheets based on inputs

reachntr

New Member
Joined
Dec 14, 2005
Messages
18
hi,

i have values from multiple sheets...

sheet2

for territory 10

10 17 18 20 21 25 26 30
229 346 241 582 322 523 290 229


sheet3
for territory 11

10 17 18 20 21 25 26 30
223 246 341 482 352 423 390 329


now in sheet1 if select 10 or 11 for territory and select 20 for class it should display the correct value from correct sheet. How to do it?


Thanks
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

Watch MrExcel Video

Forum statistics

Threads
1,118,530
Messages
5,572,706
Members
412,481
Latest member
nhantam
Top