Reference another worksheet, based on the drop down selection of another cell

[VTX]

I have a worksheet 'sheet1' that has a drop down list in cell M6. The drop down list contains the names of the other worksheets. Cell N7 contains the following formula that references the other worksheets:

Please Login or Register  to view this content.

The '3e' that appears six times in the above formula is the name of one of the other worksheets. What I would like to do is have the formula reference the worksheet name in the drop down list of cell M6, rather than have the worksheet name hard coded into the formula.

I tried replacing the '3e' in the formula with 'INDIRECT("M6")' and I get a #N/A error. Any ideas? Thanks.

[crosservice]

Hello,

If the attached formula doesn't work, please post a sample workbook for testing. Cheers!

=IF(INDEX(INDIRECT("'" & $M$6 & "'!$B$5:$S$29"),MATCH($C$3,INDIRECT("'" & $M$6 & "'!$A$5:$A$29"),0),MATCH($C$6,INDIRECT("'" & $M$6 & "'!$F$4:$S$4"),1))="None","None",($C$6+INDEX(INDIRECT("'" & $M$6 & "'!$B$5:$S$29"),MATCH($C$3,INDIRECT("'" & $M$6 & "'!$A$5:$A$29"),0),MATCH($C$6,INDIRECT("'" & $M$6 & "'!$F$4:$S$4"),1)))-(($C$5/(SIN(RADIANS(($C$4)/2))))*2))


Regards,
Adam

[VTX]

That worked perfectly. Thank you very much!