Maybe a better example of data would be:
Matches MachineName Device
GOOD 10VHQB1 10vhqb1
BAD 12WFB21 12yt2d1
BAD 12YT2D1 14yh051


I want the Device column to scoot down one row so 12YT2D1 ends up on the
same row.

"John Desselle" wrote:

I have two columns that contain computer names. One Column C is 330 rows and
Column D is 452. What I would like to happen is to align the names in C with
their matches in D. I'm guessing I need the HLOOKUP but am not sure how to
use it.
I've been able to figure out a formula to tell me if the two cells match or
not: =IF(C2=D2,"GOOD","BAD")

Here is a sample of my data:

Matches MachineName Device
GOOD 10VHQB1 10vhqb1
BAD 12WFB21 12yt2d1
BAD 12YT2D1 14yh051
GOOD 15YT2D1 15yt2d1
GOOD 180W2D1 180w2d1