Excel Newb - fill cell based on others

D

DennisT

Joined
Oct 15, 2008
Messages
3
Reaction score
0
Hi,
I'm hoping someone could help me find out the preferred way to do this:

On one worksheet I have several cells on one line that are filled via a cascade of lookups. I now need to correlate those selections and do a lookup in another worksheet.

IE In WS1 in need to fill D1 by matching data in WS2
A1=House B1=Green C1=Withtrim D1=

In WS2
A1=House B1=Blue C1=NoTrim D1=100.00
A2=House B2=Blue C2=Withtrim D2=150.00
A3=House B3=Green C3=NoTrim D3=200.00
A4=House B4=Green C4=Withtrim D4=250.00
A5=House B5=Brown C5=NoTrim D5=300.00
A6=House B6=Brown C6=Withtrim D6=350.00
A7=Deck B7=White C7=NoTrim D7=50.00

D1 in WS1 should automatically fill with the value in D4 from WS2(250.00). How can I do this? Any hints would be appreciated.

TIA
 
Hello,

Step 1) In Sheet1 and Sheet2
Move your data one row down. In first row enter the fallowing values:
A1=Arg1
B1=Arg2
C1=Arg3
D1=Result

Step 2) In Sheet1
In cells A1:C1 enter validation:
A1= House; Deck
B1= Blue; Green; Brown; White
C1= NoTrim; Withtrim

Step 3) In Sheet2
range A1:D8 name as "mDB"

Step 4) In Sheet1
In D1 enter formula: =DGET(mDB,$D$1,$A$1:$C$2)

That's all!
 
Back
Top