VBA Vlookup using variables

**forrestgump1980** · 11-16-2016, 12:48 PM

Hi there,

I am trying to use variables within a vlookup in vba. The code i am trying to amend is:-

Please Login or Register  to view this content.

I tried to amend as so but no luck:-

Please Login or Register  to view this content.

Any help would be much appreciated.

Kind regards,

forrestgump

**Arkadi** · 11-16-2016, 12:49 PM

Hi forrest

try this instead...

Please Login or Register  to view this content.

since y and x are variables, you need to have them outside the quotes so that their value gets picked up, instead of literally the text "x" or "y"

**forrestgump1980** · 11-16-2016, 04:48 PM

Thanks Arkadi! That works great!

Re: VBA Vlookup using variables