Hi, I want to create a vlookup statement (just in Excel; not via a macro) but
I want the vlookup value to be whatever cell the user has selected (I think
this is defined as the activecell, right?).

So, for instance, if the user has selected cell A3 then my formula would be
vlookup(a3,b1:b10,1,false). But, if the user then selects cell A10 then the
formula would automatically change to vlookup(a10,b1:b10,1,false).

Can that be done?

Thanks!