dynamic references NOT using VB

[homer1661]

Hello, I hope somebody can shed some light on this problem.

I need to be able to populate a cell from user inputs that reference a worksheet, column and row selected by the user.

EG. Their are four worksheets named ws1,ws2,ws3,ws4
on ws1 cell a1=required worksheet a2=required column a3 = required row (a1 -a3 are user selected from validated cells)

a4 on ws1 needs to display the required info from a1,a2,a3 i.e worksheet,column,row

All this must be done on the worksheet(NO VB) and I cannot use the IF statement asit goes over the 10 ifs limit.

please can anybody help.

I hope the above makes sense.


Thanks
K

 

[sous2817]

In A4 does this formula work:

=INDIRECT(A1&"!"&A2&A3)

A1 has the sheet name, A2 has the column , and A3 has the row number.

 

[kpark91]

=indirect(address(a3, a2,,,a1))

 

[homer1661]

kpark91, thanks, works perfectly sous2187 thank you but I kept getting an error with you code.

Thanks again for your help.