Link to home
Start Free TrialLog in
Avatar of mldaigle1
mldaigle1Flag for Canada

asked on

Macro Excel - Multiple If conditions

Good Day Experts,

I'm have a macro that identify computers that verify if in column A (NetBiosName) start by certain letters ( "BNC" Or "VM-" Or "VMC" Or "VM8" Or "MG8")) AND if in column G (ChassisType) the value start by certain letters as well ("Oth" or "#N/").

The macro does not want to recognize the column G as value, I'm getting a mismatch error.  I changed it as Text but macro ignore the "Oth" value in column T.

Can someone help me with this little issue?

Attched is a simple of my file.   The name of the macro is VDIMachine

Thanks for your help.
:)
/mld
Book1.xlsm
ASKER CERTIFIED SOLUTION
Avatar of Rgonzo1971
Rgonzo1971

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mldaigle1

ASKER

Needed another pair of eyes...

Thanks Rozon!