VBA macro to give the value of a columns if conditions are met

Question

Let's say that i have an Excel file with 3 columns and I would like that if the first two columns contains a specific word, the macro show me the value of the cell in the third column that is on the same row of the first two columns. The values of the first two columns will always be on the same rows and the first two rows cannot contain the same words.

Maybe it can work with an Excel function like an If but i struggle to make it work. If anyone has some suggestion it will be very helpful.

Thanks :)

https://stackoverflow.com/questions/42492758/vlookup-using-2-columns-to-reference-another — BigBen, Sep 15 '22 at 15:03
Please provide enough code so others can better understand or reproduce the problem. — Community, Sep 16 '22 at 01:00

score 0 · Answer 1 · edited Sep 22 '22 at 01:04

0

You can try the InStr() function combined with an AND statement and loop through all rows.

edited Sep 22 '22 at 01:04

Jeremy Caney

7,102
69
48
77

answered Sep 15 '22 at 16:40

Tepico

13
3

As it’s currently written, your answer is unclear. Please [edit] to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Jeremy Caney Sep 22 '22 at 01:04

VBA macro to give the value of a columns if conditions are met

1 Answers1