Missing a quote or got to many extra ones in

[jak82]

Hi,

I am trying to automate some a box on the page.

I have a cell with the below

=IFERROR(GETPIVOTDATA("[Measures].[Count of c4]",Branches!$B$5,"[Query 1].[Month Name]","[Query 1].[Month Name].&["&$C$7&"]","[Query 1].[Year]","[Query 1].[Year].&["&$C$6&"]","[Query].[c30]","[Query].[c30].&["&B19&""),0)

When I hardcode B19 to ECM (Vehicle Delivery Service) Ltd it works, however if I reference it like above it doesnt pick up the value.

If I test a cell with =b19 it returns ECM (Vehicle Delivery Service)

So I think there is a missing quoate somewhere, anyone help?

Thanks

 

[Norie]

What does the formula look like with the hard-coded value?

 

[jak82]

What does the formula look like with the hard-coded value?

Was missing a [