3-Way Match

  • Hello,
    I am a novice in the VBA world but learning as needs arise and can use some support here. I have a table with 3 sets of criteria and then a user input to initiate the code. I guess it would be a 3-way match. I have the formula that I can use in each cell but the cells will be used as a validation list for the end user. The purpose of using VBA is to pre-populate the cells with one of the list choices for ease of use.


    =IF(AND($B$2=E$2,E$3<>"S",$D4="Driver"),"Running",IF(AND($B$2=E$2,E$3<>"S",$D4="Support"),"Available",""))


    Formula range E4:Y19


    In the formula, I had to us “” for a mismatch, but in the code, I would just want it to skip.
    Any guidance and help will be appreciated.



    https://www.mrexcel.com/forum/…ay-match.html#post4909485

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!