Lookup

  • Thread starter Thread starter MAX
  • Start date Start date
M

MAX

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

Thanks
 
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
 
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,))
 
Still not clear...Post sample data and explain what you are looking for.

If this post helps click Yes
 
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
 
Back
Top