Match Data on list & extract

[geeitsme]

Im using XL 2k and working on several worksheets. Im trying to create a formula to do the following.

On Hardware Wksht Tab cell B20 should extract data from HardwareLIST Wksht if it matches to cell C20 from Hardware Wksht Tab. The cell in HardwareLIST A10 is a drop down list of hardware.

C20 Specifies 4 x 8 Only
C21 Specifies 4 x 9 Only
C22 Specifies 4 x 10 Only

However the drop list contains 3 different types of 4x8's, 4x9's & 4x10s. If selected then B20 should read drop list and match criteria & return the value from HardwareLIST D10. Im having trouble formulating this one. Any hints?

Thanks
Gee

 

[Smitty]

I downloaded the addIn and I select Used Range and it highlights the columns and nothing else happens. No new browser is activated.

Silly question, but did you follow the message box prompts from there?

 

[geeitsme]

No message prompts popped up.

Anyways the formula worked for me by naming the list instead of cell referencing.

=SUMIF(WoodSizes,"eig*",amounts)
=SUMIF(WoodSizes,"nin*",amounts)
=SUMIF(WoodSizes,"ten*",amounts)

Now they add my values according to type.

Thanks for the help & quick assistance and for the colo addin.

Gee

 

[lynda1234]

Such a very amazing link!
This is an interesting discussion. thank you for sharing.
Please welcome to me.