View Single Post
 
Old 12-03-2010, 03:11 AM
vikash kumar vikash kumar is offline Windows XP Office 2003
Novice
 
Join Date: Dec 2010
Posts: 2
vikash kumar is on a distinguished road
Default Creating Lookup in Excel

Hi Gurus,

I am having a requirement, where I will have a base table as follows.

Code:
par1    parm2     parm3  job
0         0           1         A
0         1           0         B
1         0           0         C
Then I will have inputs from user for this parm1 , parm2 & parm3 from dropdown ( 0 or 3 )

like

Code:
parm1 0
parm2 0
parm3 1
So I want this to be looked up in base table to return the Job.

Can some one please help me.

Thanks in advance.
Reply With Quote