On sheet 2 I have all my reference data - 38 columns and 2559 rows, starting from cell B2 (not including column and row names). What I would like to be able to do is paste in a whole column of data to sheet 1 and if that column matches any column from sheet 2 (+/- 15% for each cell) then it returns the column name (row 1) of the column that it matches to cell C1 of sheet 1. (NB all values are formatted as percentages).

Not sure if this is possible using some kind of lookup funtion which can compare whole columns rather than just lookup a single cell.

Thanks very much
Louise