INDIRECT to change tab references in an INDEX MATCH formula

[lost_in_the_sauce]

I'm close but I can't figure this last bit out.

=INDEX(INDIRECT(B4&"!G:G"),MATCH(C4,INDIRECT(B4&"!C:C"),0))

Column B is the tab name of the tab I am trying to reference with the formula. If I evaluate formula the indirect combines the tab name in column B with !G:G but they seem to be surrounded by " instead of ' whci looks like what's causing #REF. The Index match works, I just can't get the INDIRECT to let me alter the reference tab correctly.

 

[iggydarsa]

Are there spaces in the name of the tabs? If so try this:
=INDEX(INDIRECT("'" & B4 & "'!G:G"),MATCH(C4,INDIRECT("'" & B4 & "'!C:C"),0))

 

[lost_in_the_sauce]

Are there spaces in the name of the tabs? If so try this:
=INDEX(INDIRECT("'" & B4 & "'!G:G"),MATCH(C4,INDIRECT("'" & B4 & "'!C:C"),0))

....yes, yes there are. Thank you so much.