CODEWITHSUNDEEP
excelexcel-formula
AmberN
AmberN

Reputation: 3

Pull text from another cell into an INDIRECT formula

I'm using the INDIRECT formula to extract data from specific cells in hundreds of different sheets. In column B, I've listed all of the cells I need data from, and the worksheet names are in row 6. Any suggestions on how to exract the cell number from column B?

I've tried using text strings and the CONCATENATE function, but because of the quotations, I'm getting a reference error. 

=INDIRECT("'"&$C$6&"'!M8")

I want to pull data from cell M8 in every sheet, but "M8" is listed in cell B2.

Upvotes: 0

Views: 748

Answers (1)

dwirony
dwirony

Reputation: 5450

Try:

=INDIRECT("'"&$C$6&"'!"&B2)

You have to use the Value in cell B2.

Upvotes: 1

Related Questions