(Msg. 2) Posted: Mon Nov 16, 2009 8:58 am
Post subject: RE: Index [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Another way using VLOOKUP(). Make sure the text mentioned in the formula or
reference cell is exactly same as mentioned in row headers and column headers
'with the lookup values in F1 and F2
=VLOOKUP(F1,A1:E10,MATCH(F2,A1:E1,0),0)
If this post helps click Yes
---------------
Jacob Skaria
"msao" wrote:
> please help with this need to recive the intercection between loose And
> exposed answer shold be E.
>
> Shelterd Partially Shelterd Eposed Extremely
> Exposed
> Very Loose E D C
> A
> Loose G F E
> B
> Average J I H
> F
> Tight K J I
> G
> Very Tight L L L
> L
>
> Thank you for the Help
(Msg. 3) Posted: Mon Nov 16, 2009 11:05 am
Post subject: Re: Index [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
I entered you data such that the word "Sheltered" in in B1, and "Very Loose"
is in A2, etc
In G1 I enter Loose and in H1 I entered Exposed
In J1 I used the formula =INDEX(B2:E6,MATCH(G1,A2:A6,0),MATCH(H1,B1:E1,0))
to get the answer E
As a second experiment, I selected A1:E6 and use Create Names. Now, for
example, D2:D6 is called Exposed while B3:E3 is called Loose
A formula such as = Loose Exposed will return the intersection. The space in
this formula is the 'intersection operator'
"msao" <msao RemoveThis @discussions.microsoft.com> wrote in message
news:868E857A-C8DE-4DAF-8DF0-32CCC04A8E43@microsoft.com...
> please help with this need to recive the intercection between loose And
> exposed answer shold be E.
>
> Shelterd Partially Shelterd Eposed
> Extremely
> Exposed
> Very Loose E D C
> A
> Loose G F E
> B
> Average J I H
> F
> Tight K J I
> G
> Very Tight L L L
> L
>
> Thank you for the Help
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office