Creating Lookup in Excel

vikash kumar · #1 12-03-2010, 03:11 AM

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.

BjornS · #2 12-05-2010, 08:18 AM

Hi,
see attachment for a solution.

Yellow cells = input
Blue cells = formulas

Kind regards
Bjorn

vikash kumar · #3 12-06-2010, 06:50 AM

Thanks a lot Bjorn! It was really helpful.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Creating Sharepoint Folders from Excel VBA	rst	Excel	0	11-16-2009 11:39 AM
Excel to lookup Access Database	PeterP	Excel	1	06-11-2009 12:33 PM
creating unique numbers in excel	bignick270	Excel	1	05-17-2009 05:40 AM
Using the LOOKUP Command	Grapejuice	Excel	2	10-15-2008 02:02 PM
Creating a Distrubution List from Excel	webphotogeek	Outlook	0	01-10-2008 11:21 AM