santeria...I really don't see how a thread about the limitations of XL's column count corresponds to the OP's questions about VLookups?santeria said:This might help about column limits:
http://www.mrexcel.com/board2/viewtopic.php?t=69341&highlight=column+limit
Microsoft Excel Help said:Col_index_num is the column number in table_array from which the matching value must be returned. A col_index_num of 1 returns the value in the first column in table_array; a col_index_num of 2 returns the value in the second column in table_array, and so on. If col_index_num is less than 1, VLOOKUP returns the #VALUE! error value; if col_index_num is greater than the number of columns in table_array, VLOOKUP returns the #REF! error value.