| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Column reference in Vlookup formula
There are time when I need to add column to the section of the spreadsheet
that I'm referencing in my vlookup formula. When I add a column, the vlookup formula adjusts the range but it doesn't change (i.e. increment) the existing column references so all of the data retrieved is bad because it's now referencing the wrong column. Is there a way to fix this without doing a massive 'find and replace'? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Row reference formula not working with a VLookup | Excel Worksheet Functions | |||
| Vlookup with Multiple like values in the reference column | Excel Worksheet Functions | |||
| VLookup Column Reference - can it increment when copying to subseq | Excel Worksheet Functions | |||
| VLookup using 2 worksheets, whole column reference | Excel Worksheet Functions | |||
| Need Vlookup to work with formula in reference cell | Excel Discussion (Misc queries) | |||
![Kevin K[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
