Very final post today-

I want to write a macro so that in column b of row 'x' of a spreadsheet
I will have a vlookup that will look at all the previous lines of the
spreadsheet.

I thought I could get around doing this by vlooking up all of the
column. However, this creates a circular reference that I cannot
find... so second question- is there any sort of 'if' statement that
would delete a circular reference and instead write text such as '#N/A'
or 'HERE'?

Many thanks.

Solomon