<a wrote in message ...
hi,

I have 2 sheets in my workbook,

sheet 1 contains the main analysis of my data

sheet 2 contains a table which I will reference with VLOOKUP from sheet 1


I have written the following VBA code

I might be missing something here, but why VBA code? Won't just an ordinary
VLOOKUP do what you want, especially as it's looking up a sheet in the same
workbook?