Posted to microsoft.public.excel.misc

Hamsa

external usenet poster

Posts: 3

clarification on VLOOKUP

VLOOKUP(lookup_value,table_array,col_index_num,ran ge_lookup)

If I use MONTH(TODAY()) in place of col_index_num, I am getting an error.

I have also tried TODAY() in cell A1, MONTH(A1) in cell B1 and
B1 in place of col_index_num. I still get an error.

Is it allowed ? Is there an alternative?

Thanks in advance for any valuable guidance
Hamsa

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
Clarification	pmayne181	Excel Discussion (Misc queries)	1	December 2nd 08 12:56 PM
countif clarification	LInda	Excel Discussion (Misc queries)	9	March 31st 06 12:55 AM
If Then Statement Clarification	Joanne	Excel Discussion (Misc queries)	3	January 30th 06 09:26 PM
Beyond VLOOKUP Clarification	nebb	Excel Worksheet Functions	2	July 3rd 05 10:30 PM
If and Dates Clarification	wal50	Excel Worksheet Functions	4	January 4th 05 06:31 PM

All times are GMT +1. The time now is 10:55 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us