That is possible using the VLOOKUP function. Look it up in the help screens.
When you become familiar with it, it is a very powerful tool.

"Jennifer Stevenson" wrote:

I have two databases that I am trying to merge into a single excel worksheet.
The first column in each database is a unique ID number associated with the
data in a single row. I need to line up the unique ID columns (one from each
database) in order to merge the data. The problem is that the two databases
do not have the same number of entries. For example,

UniqueID1 UniqueID2
1 1
2 3
3 4
4 5

and I would like to sort or line up the columns so that it looks like this

UniqueID1 UniqueID2
1 1
2
3 3
4 4
5

and leave blanks where they do not match up. Is this possible to do easily
in Excel?

Thanks!