Using indirect within a Vlookup

Hi,

Can Vlookup and Indirect be used within the same formula?

Currently I have the formula:
=IFERROR(VLOOKUP(A3,'111'!G:L,6,FALSE),0)

But ideally I would like it to look in cell C2 to obtain this part '111'. In Cell C2 It contains "111 Inverurie NEW" so usually to obtain the 111 I use the formula: Value(Left(C2,3)).

Can anyone help please?

Thanks Again ACE!!!!