Hi

I have many vlookups in a spreadheet to look up a specific value in many
columns.

Is there a way to have a macro to fill up these columns instead of having
dozen
of vlookup in the file?

regards, xlsops