dropdown to populate numerical value of cell in formula

[blueroost]

Is it possible to split the cell value of a formula, to make the numerical part selectable from a dropdown?

As an example ='sheetA'!Q(value of C3 on sheetB which is a dropdown list numerical value)

Hopefully this makes sense...

Thanks in advance

 

[Marcílio_Lobão]

blueroost, Good afternoon.

Try to use:

=INDIRECT("sheetA!Q" & SheetB!C3)

Is that what you want?

I hope it helps.