Posted to microsoft.public.excel.misc

Tblack78

external usenet poster

Posts: 1

increasing the row_index_num when you drag a formula

Here is my formula...

=HLOOKUP("Set #",'College Drop'!$1:$1048576,3,FALSE

I would like the row_index_num to increase as I drag the formula down.

Any help would be appreciated.

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
day increasing by 1 when i drag and drop	dencara	Excel Worksheet Functions	4	May 10th 08 07:09 PM
Hlookup-row_index_num question	Eden397	Excel Worksheet Functions	4	November 10th 07 06:01 PM
Row_Index_Num Increment	Jani	Excel Worksheet Functions	4	October 2nd 06 06:41 PM
Increasing distance labels using drag down method	Bowbender	Excel Worksheet Functions	2	September 20th 05 09:25 PM
Changing the Row_index_num via HLOOKUP	Mr. G.	Excel Worksheet Functions	2	May 2nd 05 05:30 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us