|
|
| Next: Excel 2007 |
| Author |
Message |
MAX
External
Since: Dec 10, 2004
Posts: 11
|
 Posted: Tue Nov 03, 2009 8:15 am Post subject: Lookup
Archived from groups: microsoft>public>excel>worksheet>functions (more info?) |
|
|
|
| I am using MS lookup wizard and I want more than 2 parameters. how is it
possible to use more parameters?
Thanks
|
|
|
| Back to top |
|
 |
Jacob Skaria
External
Since: Mar 04, 2009
Posts: 441
|
Posted: Tue Nov 03, 2009 8:49 am Post subject: RE: Lookup [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?) |
|
|
Do you mean
=LOOKUP(A1,b1:b10,c1:c10)
or
=lookup(lookup_value,{1,2,3,4},{"a","b","c","d"})
If this post helps click Yes
---------------
Jacob Skaria
"MAX" wrote:
> I am using MS lookup wizard and I want more than 2 parameters. how is it
> possible to use more parameters?
>
> Thanks |
|
| Back to top |
|
|
MAX
External
Since: Dec 10, 2004
Posts: 11
|
Posted: Tue Nov 03, 2009 9:06 am Post subject: RE: Lookup [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?) |
|
|
Sorry, this is something new for me. All I can tell you is that I am having
this lookup formula.
=INDEX($A$1:$I$21, MATCH(E24,$A$1:$A$21,), MATCH(D24,$A$1:$I$1,))
"Jacob Skaria" wrote:
> Do you mean
> =LOOKUP(A1,b1:b10,c1:c10)
>
> or
>
> =lookup(lookup_value,{1,2,3,4},{"a","b","c","d"})
>
> If this post helps click Yes
> ---------------
> Jacob Skaria
>
>
> "MAX" wrote:
>
> > I am using MS lookup wizard and I want more than 2 parameters. how is it
> > possible to use more parameters?
> >
> > Thanks |
|
| Back to top |
|
|
Jacob Skaria
External
Since: Mar 04, 2009
Posts: 441
|
Posted: Tue Nov 03, 2009 9:11 am Post subject: RE: Lookup [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?) |
|
|
Still not clear...Post sample data and explain what you are looking for.
If this post helps click Yes
---------------
Jacob Skaria
"MAX" wrote:
> Sorry, this is something new for me. All I can tell you is that I am having
> this lookup formula.
> =INDEX($A$1:$I$21, MATCH(E24,$A$1:$A$21,), MATCH(D24,$A$1:$I$1,))
>
> "Jacob Skaria" wrote:
>
> > Do you mean
> > =LOOKUP(A1,b1:b10,c1:c10)
> >
> > or
> >
> > =lookup(lookup_value,{1,2,3,4},{"a","b","c","d"})
> >
> > If this post helps click Yes
> > ---------------
> > Jacob Skaria
> >
> >
> > "MAX" wrote:
> >
> > > I am using MS lookup wizard and I want more than 2 parameters. how is it
> > > possible to use more parameters?
> > >
> > > Thanks |
|
| Back to top |
|
|
T. Valko
External
Since: Nov 24, 2006
Posts: 3426
|
Posted: Tue Nov 03, 2009 11:29 am Post subject: Re: Lookup [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?) |
|
|
Provide some specific details.
--
Biff
Microsoft Excel MVP
"MAX" <MAX.RemoveThis@discussions.microsoft.com> wrote in message
news:ED8E0828-5F22-4F1A-A729-156FD7E78AFA@microsoft.com...
>I am using MS lookup wizard and I want more than 2 parameters. how is it
> possible to use more parameters?
>
> Thanks |
|
| Back to top |
|
|
T. Valko
External
Since: Nov 24, 2006
Posts: 3426
|
Posted: Tue Nov 03, 2009 12:27 pm Post subject: Re: Lookup [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?) |
|
|
See if this helps:
...........A..........B..........C..........D
1....................X..........Y..........Z
2......Joe........5............7..........2
3......Sue........4...........2..........6
4.....Lisa........6...........6..........8
You want to lookup Sue and Y:
A10 = Sue
B10 = Y
=VLOOKUP(A10,A1:D4,MATCH(B10,A1:D1,0),0)
result = 2
--
Biff
Microsoft Excel MVP
"MAX" <MAX DeleteThis @discussions.microsoft.com> wrote in message
news:98B3F9F7-9295-4753-9208-CD9CABCAC2F2@microsoft.com...
> Sorry, this is something new for me. All I can tell you is that I am
> having
> this lookup formula.
> =INDEX($A$1:$I$21, MATCH(E24,$A$1:$A$21,), MATCH(D24,$A$1:$I$1,))
>
> "Jacob Skaria" wrote:
>
>> Do you mean
>> =LOOKUP(A1,b1:b10,c1:c10)
>>
>> or
>>
>> =lookup(lookup_value,{1,2,3,4},{"a","b","c","d"})
>>
>> If this post helps click Yes
>> ---------------
>> Jacob Skaria
>>
>>
>> "MAX" wrote:
>>
>> > I am using MS lookup wizard and I want more than 2 parameters. how is
>> > it
>> > possible to use more parameters?
>> >
>> > Thanks |
|
| Back to top |
|
|
|
|
Microsoft Office