| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Align matching cells of two different columns
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help: Sorting 2 columns according to matching cells, and fishing for duplicates | Excel Discussion (Misc queries) | |||
| Format and Align Columns | New Users to Excel | |||
| Filtering Columns to Align Matching Data | Excel Worksheet Functions | |||
| Matching Cells/columns | Excel Worksheet Functions | |||
| Compare cells/columns and highlight matching text strings | Excel Worksheet Functions | |||
Threaded Mode
