I am not sure I understood your query. Are you looking at a formula to check
whether a record in the range exists with more than 1 lookup_value (exact
match to each cell in the same row). Could you please elaborate and post what
you are expecting as the formula result

If this post helps click Yes
---------------
Jacob Skaria


"MAX" wrote:

I am using the lookup wizard for a table shown below. The lookup wizard gives
access for only 2 parameters, column A and any other column in the table.
Does the wizard can give access for 4 parameters?
Thanks

A B C D E
1 No Col ID Index
2 01/01/09 1 blue 123 abc
3 08/01/09 2 red 456 def
4 24/02/09 3 yellow 789 ghi
5 31/03/09 6 green 654 jkl
6 05/05/09 5 pink 258 mno
7 07/07/09 23 black 369 pqr
8 22/10/09 4 white 741 stu