I know this can be accomplished with a vlookup or index match, but I need this to work in VBA. Is this possible?
I tried using the application function but can't get it to work with more than 1 criterion.
Let's say we have a Price Table in worksheet 5 with the following info: column 1: size column 2: color column 3: weight column 5: price
I need to return the value in the 5th column based on 3 criteria found in columns 1, 2, 3. I want to only return the price if size = large, color = yellow, weight = 2
Any ideas?
