Posted to microsoft.public.excel.misc

Rich

external usenet poster

Posts: 298

Excell VLookup

Hi All

I am trying to set the "table_array' part of this formula an individual
cell. For '15.04.08'!A3:K38 as cell A7 or cell A7!A3:K38

=VLOOKUP(A8,'15.04.08'!A3:K38,7)

Basically trying to define which worksheet to look in for the value.

Hope this makes sense

Cheers

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
how do I use vlookup in excell 2007?	trainerjones	Excel Discussion (Misc queries)	2	July 1st 07 08:52 PM
Excell Vlookup formula	naurel	Excel Worksheet Functions	1	June 18th 07 02:40 PM
How to open MS Excell 2007 Sheet in MS Excell 2000???	Alek Luchnikov	New Users to Excel	1	March 22nd 07 04:40 PM
create a slides show with excell spreadsheets using excell	wantabepas	Charts and Charting in Excel	0	June 16th 06 07:46 PM
how do you open an excell email attacment, if I dont have excell	Gary	Excel Discussion (Misc queries)	1	February 22nd 06 10:26 PM

All times are GMT +1. The time now is 01:17 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us