variable and fixed sheet name in formula

[phairplay]

Hi Guys,

I have a code that opens up and stores a workbook.name (wb.name) and then a array that loops through sheet names (.arrSht(I))

how do I include the word "Breakdown" at the end of arrSht(I) in the below formula.

"=VLOOKUP(RC[-2],'[" & wb.Name & "]" & arrSht(I) & "'!C1:C2,2,0)"

many thanks

 

[JackDanIce]

Do you mean:

"=VLOOKUP(RC[-2],'[" & wb.Name & "]" & arrSht(I) & "Breakdown'!C1:C2,2,0)"

 

[phairplay]

thank you for the quick reply.
I was adding "" around the breakdown Doh!

 

[JackDanIce]

lol live and learn! You're welcome