LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 14th 12, 01:27 PM posted to microsoft.public.excel.newusers
external usenet poster
First recorded activity by ExcelBanter: Apr 2011
Posts: 14
Default remove columns from a lookup table


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 ?



Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
lookup help. lookup result based on data in 2 columns lcc Excel Worksheet Functions 3 April 6th 10 01:20 PM
Find a value Using a lookup table multiple columns and rows glasspumpkin Excel Worksheet Functions 4 July 2nd 08 04:21 PM
Possible VB code to lookup and remove unwanted data Sarah (OGI) Excel Discussion (Misc queries) 3 December 11th 07 02:18 PM
Returning Columns to a List Box for a Holiday LookUp Table Noggy1 Excel Programming 1 October 12th 05 06:49 PM
Pivot table doing a lookup without using the lookup function? NGASGELI Excel Discussion (Misc queries) 0 August 2nd 05 05:08 AM

All times are GMT +1. The time now is 02:06 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017