Hi everyone,
I'm new to the forum, and I have a problem in VBA that I cant seem solve!!!
To explain, I am having problem with the VBA code for multiple lookups. I have three columns in a worksheet. The first column contains a list of dates and the second column contains a list of product codes. I am trying to populate the third column with the price of the product.
In a different worksheet I have three columns, which are the dates, product codes, and the prices for each of the products. The issue is the price of the product changes each year for each product, so I need to find the price on or after the date is updated for each product. I have attached the two sheets as example if it helps, can someone please help with the VBA for this example, thanks
Reply With Quote