remove columns from a lookup table

D

dido22

Hello,

I have a complex workbook of which the first sheet is a large lookup table.
It is accessed via 'VLOOKUP' from many parts of the workbook.

5 columns of the lookup table are now redundant and I would like to delete
them, ie. delete the columns themselves, not just the data within them
(which has already been deleted). If I do so, it messes up the rest of the
workbook, because the Vlookup function uses a 'column numbers' , which has
to be changed.

I can get over it by just making the columns invisible, but are there any
other mor elegant solutions ?

Thanks

KK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top