Posted to microsoft.public.excel.misc

AirgasRob

external usenet poster

Posts: 21

VLOOKUP with INDIRECT

I would like the formula to reference cell A43 to know which worksheet to go
to and use it as the lookup criteria for VLOOKUP. Below is the formula I have
but it is not working, I am getting #VALUE! as a result.

=VLOOKUP($A$43,INDIRECT("'" & $A$43 & "'!" & $A$3:$AB$30),5,FALSE)

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
Indirect VLookup	mcp201	Excel Discussion (Misc queries)	1	May 2nd 08 09:50 PM
VLOOKUP WITH INDIRECT	excelent	Excel Discussion (Misc queries)	3	March 13th 08 02:42 PM
VLOOKUP & INDIRECT	Graham Y	Excel Discussion (Misc queries)	2	April 3rd 07 04:18 PM
Indirect/Vlookup/???	Light	Excel Discussion (Misc queries)	2	October 5th 06 02:05 PM
Indirect Vlookup with RC[-1]	outwest	Excel Worksheet Functions	6	March 12th 06 10:08 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us