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.