Currently I am working on a spreadsheet that will take information entered on
a sheet called Profile and put it onto a 2nd sheet called Mail Merge. The
question I have is this, I am trying to find an easy way to make this happen
without having to fill in each cell with the function. Currently, I am doing
one cell at a time.

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.

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

Thank you for your help...

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 .