Vlookup() or Index() - How to select muitiple in Range_array

[rsk]

Pls find the below example file.

I need to find value of H2:I5


http://www.2shared.com/document/Qcr6M8vj/mulrange.html

 

[rsk]

Answer should be

Name open close process

Mr.X 1 2 3

Mr.Y 4 5 6

Mr.Z 7 8 9

Mr.Q 10 11 12

 

[NARAYANK991]

Hi ,


Enter the following formula in G2 , as an array formula ( using CTRL SHIFT ENTER ) :


=INDEX($C$2:$C$13,MATCH($F2&LEFT(G$1,FIND(" ",G$1)-1),$A$2:$A$13&$B$2:$B$13,0))


Copy this to all the other cells up to I5.


Narayan

 

[rsk]

its not working Mr.Narayank

 

[NARAYANK991]

Hi ,


Can you specify what problem you are facing ? Do you want me to upload the file ? Can you use Skydrive or GoogleDocs ?


Narayan

 

[rsk]

can you pls upload the file in any link, so that i can understand better


Thanks you very much for your response

 

[NARAYANK991]

Hi ,


Check the following link :


https://skydrive.live.com/view.aspx?cid=754467BA13646A3F&resid=754467BA13646A3F%21162


Narayan

 

[rsk]

Sorry for trouble you,


=VALUE(INDEX($C$2:$C$13,MATCH($F2&LEFT(G$1,FIND(" ",G$1)-1),$A$2:$A$13&$B$2:$B$13,0)))


above formula gives #VALUE!

 

[NARAYANK991]

Hi ,


Please note that all the formulae are array formulae , to be entered using CTRL SHIFT ENTER.


Narayan