Dear VBA Gurus,

My question has been probably been answered tons of time here in this Forum, but unfortunately, I couldnt find a discussion that could help me (maybe, I searched with wrong words).

I have a few If Formulas:

=IF(A2="T020"; IF(H2="VMI";"CSDM";IF(H2="DC";"CSDM";IF(H2="MFG";"PPDS";"SNP"))))
=IF(A2="T023"; IF(H2="MFG";"PPDS";IF(H2="Toll";"PPDS";"SNP")))
=IF(A2="T124"; IF(H2="DC";"CSDM";"SNP"))
=IF(A2="T007"; IF(H2="MFG";"Site ISO";IF(H2="ExM";"ExM ISO"; IF(F2="1480"; "ExM ISO"))))


I would like to run a VBA code for it (preferably on comand with a button), that returns the result in a column (e.g. AA).

The IF Formulas will be checking minimum 12k of rows in my excel report.

Thank you very much every hint or ideas.

Kind regards

Nxvle