Hi Barbara
Column() returns the column number A=1 B=2 etc.
In your formula, the use of COLUMN() is automatically stepping up the offset
argument in the Vlookup expression to choose the appropriate value from the
reference table.

--
Regards
Roger Govier
"Barbara" wrote in message
...
Yes the VLookup is working nicely. Thanks
One question though, I understand what everything is doing in the formula
except Column()
Is that giving it a variable for whatever is in the column to copy over?
Barbara