Creating Lookup in Excel

[vikash kumar]

Hi Gurus,



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

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

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.

[BjornS]

Hi,
see attachment for a solution.

Yellow cells = input
Blue cells = formulas

Kind regards
Bjorn

[vikash kumar]

Thanks a lot Bjorn! It was really helpful.