VBA Code Help

[WarriorKing]

If somebody could help...

In Columns D and H I have 2 drop down lists and I want Column I to populate with a cost associated to the values in D & H. Would somebody help me with the coding?

 

[Joe4]

Welcome to the Board!

I think you are missing some critical details.
How is the cost associated with it determined by the values in columns D and H?
Is there some sort of lookup table somewhere you are matching to?
Or is there some sort of formula that uses the values in columns D and H?

Perhaps it would be helpful to show us an example and your expected output.
MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[WarriorKing]

Hi,

Column D has a drop down list of 5 companies
Column H has a drop down list of 4 vendors

What I am looking to do is when Column D has one company populated with a vendor from Column H, I want Column I is populate with the cost associated with the Vendor from Column H. I have a table with associated costs.

I hope this helps...

 

[Joe4]

Hi,

Column D has a drop down list of 5 companies
Column H has a drop down list of 4 vendors

What I am looking to do is when Column D has one company populated with a vendor from Column H, I want Column I is populate with the cost associated with the Vendor from Column H. I have a table with associated costs.

I hope this helps...

You should be able to use an XLOOKUP formula with multiple criteria.
See here for details and examples: XLOOKUP with multiple criteria

If you cannot figure out how to do this from that link, please post exactly what you cost reference table looks like, and let us know exactly what range it exists in.