VLOOKUP formula, cell reference as column index number

Originally Posted by Bobz1983

Thanks for that. I think it didn't work before because I didn't have both files open.

Yes, if using the INDIRECT function to build a reference to another file that file must be open for the formula to work properly.