If you're using Vlookup...you probably know the column to pull from...so you can probably use Address function....


e.g. =Address(Match(A1,X1:X100,0),3)


where 3 is the column number (starting count from column A) where the Vlookup pulled value would be coming from...

Note: The range within the match function must start at row 1 (or you can add the number of rows you offset by at the end of the Match function---eg. =Match(A1,X5:X100,0)+4