I have a working VLookup formula placed into cell B3 in Table 1, copied below. The formula uses a concatenation of: $A3 & "_" & C$2 as the lookup value. Table 2 on Sheet2 has the same concatenation in column C, as shown on the attached 'Book1'.
=VLOOKUP($A3 & "_" & C$2, Sheet2!$C$3:$D$8, 2, FALSE)
I have tried to adapt this formula for use within VBA code, but have not hit on the right version.
Assistance gratefully received.