VegasBurger wrote...
....
Addtional information, one of the cells I am working with on the Profile
sheet is actually 2 cells merged (ex: A3:A4) the rest of the cells are not
merged.

Merged cells are usually difficult to work with.

Current function being used: =LOOKUP(Profile!A4;Profile!A4)

This is a do-nothing function call. Simplify to =Profile!A4 .