| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA VLookup Reference Problem
I'm trying to simplify the process of vlookups for others and have trie
the following. This is intended to look at the adjacent cell to th left(containing a branch code) and fill in the corresponding branc name. I have the Vlookup data on a hidden sheet in the workbook. M problem is that the lookup range moves with the active cell. Any hel would be greatly appreciated. Thanks, Scott Selection.FormulaR1C1 = _ "=VLOOKUP(OFFSET(RC,0,-1),Lookups!R[-1]C[-1]:R[43]C,2,FALSE)" Selection.Copy Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone SkipBlanks:= _ False, Transpose:=False Application.CutCopyMode = Fals -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup with more than one reference with the same name | Excel Worksheet Functions | |||
| Reference - Vlookup | Excel Discussion (Misc queries) | |||
| Vlookup reference the row below | Excel Worksheet Functions | |||
| VLOOKUP Reference Help | Excel Discussion (Misc queries) | |||
| Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions | |||
Threaded Mode
