Lookup
 

I am using MS lookup wizard and I want more than 2 parameters. how is it
possible to use more parameters?

Thanks

Lookup
 

Provide some specific details.

--
Biff
Microsoft Excel MVP


"MAX" wrote in message
...
I am using MS lookup wizard and I want more than 2 parameters. how is it
possible to use more parameters?

Thanks

Lookup
 

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

Lookup
 

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

Lookup
 

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

Lookup
 

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" wrote in message
...
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