Lookup Wizard
"Jacob Skaria" wrote:
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
Sorry I forgot to tell you that I'm a beginner on lookup.
All I want is that when I choose for example the date 07/07/09 in the lookup
wizard, I will have the answer: 23 - black - 369 and the lookup value is
pqr.
Thanks a lot.
|