Posted to microsoft.public.excel.worksheet.functions

Yossy

external usenet poster

Posts: 127

Edit links - in Vlookup

I multiple sheets with cells that are linked via lookup to another Workbk.
How do I expand the data range of the Vlookup without manually adjusting each
Vlookup formula.

My existing vlookup is something like this. =vlookup(c5,
OtherSheet!B5:J10,2,false) but now the data range from OtherSheet has
extended to B5:J99.

All help totally appreciated. I use Excel 2007. Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Edit links	vbcraft	Excel Discussion (Misc queries)	1	July 23rd 08 08:13 PM
Update links box gives Continue or Edit Links dialog	KarenF	Excel Discussion (Misc queries)	0	May 18th 07 01:17 PM
edit links	Shooter	Excel Worksheet Functions	3	April 4th 07 10:46 PM
Edit Links: Changing links on a protected worksheet	Halibut68	Excel Discussion (Misc queries)	0	April 28th 06 11:03 AM
edit links	tsjoek	Excel Worksheet Functions	0	March 18th 05 03:11 PM

All times are GMT +1. The time now is 07:42 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us