Lookup Wizard
Hi,
I'm not sure I understand but here's a formula that looks up columns A, B, C
& D and returns column E
=INDEX(E2:E8,MATCH(1,(A2:A8=F2)*(B2:B8=F3)*(C2:C8= F4)*(D2:D8=F5),0))
The lookup values go in f2, f3, f4 & f5 and it is an *ARRAY* formula
This is an array formula which must be entered by pressing CTRL+Shift+Enter
'and not just Enter. If you do it correctly then Excel will put curly brackets
'around the formula {}. You can't type these yourself. If you edit the formula
'you must enter it again with CTRL+Shift+Enter.
Mike
"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
|