Lookup

[MAX]

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

Thanks

 

[T. Valko]

Provide some specific details.

 

[Jacob Skaria]

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

 

[MAX]

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]

Still not clear...Post sample data and explain what you are looking for.

If this post helps click Yes

 

[T. Valko]

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,A14,MATCH(B10,A11,0),0)

result = 2