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