LOOKUP Command Issue

V

VegasBurger

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...
 
H

Harlan Grove

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.
Click to expand...

Merged cells are usually difficult to work with.
Current function being used: =LOOKUP(Profile!A4;Profile!A4)
Click to expand...

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