Vlookup in another file
Posted by Dan on January 23, 2001 6:34 AM
Attempting to use "vlookup" to find information in one workbook and return it to another. Do not have any problem using this function within the same workbook but it appears to have a problem when I go to another workbook to draw info. The problem appears to be with the "col_index_num" function trying to find the column to use in the formula. Examples:
Within same spreadsheet -
Trying to get info from another spreadsheet
where "Sample.xls" is the other workbook and A! is the worksheet in the "Sample.xls" workbook that contains the info I am trying to retrieve.
Have also tried with no luck:
Any suggestions ?