Thread: Lookup Wizard
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 390
Default Lookup Wizard

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