Posted by Chas on January 24, 2002 11:04 PM
I have 2 spreadsheets with similar data. On sheet 2, I want a VLOOKUP formula to search a column on sheet 1 and when it finds the exact match it returns the data in the same row as the match but 5 columns over. I can get it to return an "x" or any specific word, but not the contents of an adjacent cell because they are not on the same row #'s from sheet to sheet.
Any ideas out there?
Any help is greatly appreciated.