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