ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   VLOOKUP with a non-numerical columindex number (https://www.excelbanter.com/excel-worksheet-functions/118068-vlookup-non-numerical-columindex-number.html)

Ian W.

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

Biff

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





All times are GMT +1. The time now is 12:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com