dynamic build

  • Thread starter Thread starter shank
  • Start date Start date
S

shank

='UNITED ARAB'!$B$4
UNITED ARAB is in column A2 of present worksheet.

How do I build a formula to concatenate A2 into: ='UNITED ARAB'!$B$4
Should look something like: =A2+!$B$4
But my syntax is messed up.

thanks
 
Back
Top