Posted to microsoft.public.excel.worksheet.functions

Kashyap

external usenet poster

Posts: 131

Indirect with index and match

Hi, I have the below formula where it flech data from sheet as per C5.. In
this case it is 'PRX'..

=INDEX(PRX!G1:G100,MATCH(1,(C7=PRX!C1:C100)*(F7=PR X!D1:D100)*(J9=PRX!E1:E100)*(C12=PRX!F1:F100),0))

How can I use indirect ref to sheet with this formula?

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
index(match) Wind Uplift Calculations (match four conditions)	JMeier	Excel Worksheet Functions	8	August 1st 08 01:45 AM
External Reference with INDIRECT, INDEX/MATCH	ScottS	Excel Worksheet Functions	4	June 25th 08 05:59 PM
Indirect function in Index/Match Array	hoosier41	Excel Discussion (Misc queries)	5	June 20th 08 10:09 PM
Match, Index, Indirect ?	PCLIVE	Excel Worksheet Functions	1	April 6th 07 05:02 PM
Index,Indirect, and Match	caldog	Excel Worksheet Functions	3	November 10th 06 11:57 PM

All times are GMT +1. The time now is 06:36 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us