| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP with a non-numerical columindex number
Hello, I'm trying to write a vlookup that is refrencing a letter for the
column index number instead of a numerical value. I keep getting the "#REF" error when I try to do so. Does anyone have any ideas? I'd really appricate any help I could get. -Ian |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLOOKUP with a non-numerical columindex number
You need to provide some details. The column_index_number MUST be a number.
Biff "Ian W." wrote in message ... Hello, I'm trying to write a vlookup that is refrencing a letter for the column index number instead of a numerical value. I keep getting the "#REF" error when I try to do so. Does anyone have any ideas? I'd really appricate any help I could get. -Ian |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I automatically update column index number in VLookup whe. | Excel Worksheet Functions | |||
| vlookup Function Help Needed | Excel Worksheet Functions | |||
| Lookup Data in two seperate Spreadsheets | Excel Worksheet Functions | |||
| Program Column B to record numerical range based on number in colm | Excel Discussion (Misc queries) | |||
| VLOOKUP first numerical value (not text) | Excel Worksheet Functions | |||
Linear Mode
