| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using activecell in vlookup
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If activecell.column = variable then activecell,offset (0,1) | Excel Discussion (Misc queries) | |||
| ActiveCell or ActiveSheet | Excel Worksheet Functions | |||
| ActiveCell in a Range? | Excel Discussion (Misc queries) | |||
| activecell & Vlookup | Excel Discussion (Misc queries) | |||
| Defining an Activecell | Excel Discussion (Misc queries) | |||
Threaded Mode
