Hi All,
I'm pretty certain that this should be straight forward, having suffered a rather large brain fart i cant remember
how to use activecell.row in a vlookup.
with this it would be something along the lines of =Vlookup(AM & row,sheet1,B:C,2,false)
But i cant get this working
I'm pretty certain that this should be straight forward, having suffered a rather large brain fart i cant remember
how to use activecell.row in a vlookup.
with this it would be something along the lines of =Vlookup(AM & row,sheet1,B:C,2,false)
But i cant get this working