CODEWITHSUNDEEP
excelexcel-formulaformula
Dodo
Dodo

Reputation: 55

Excel "INDIRECT" function with parameter from "CONCATENATE"

I am using an INDIRECT function to get value of a cell (B4) for many sheets in my workbook. At the moment I have to hard code the name of the sheets like this 

=INDIRECT("WCNEXP!$B$4")

Ideally I would like to find a way to compile the name "WCNEXP" with the help of the CONCATENATE formula, like this 

=INDIRECT("CONCATENATE(B18,C18)!$B$4")

but it does not work for some reason.

Is there another way to get the name compiled from 2 cells and use the INDIRECT Formula ?

Photo of the workbook

Upvotes: 0

Views: 2795

Answers (1)

MikeR
MikeR

Reputation: 71

Your code is almost good. the quotes must be placed after the concatenate function, and with the use of "&" to join them. 

=INDIRECT(CONCATENATE(B18,C18)&"!$B$4")

Upvotes: 1

Related Questions