Match and align columns

**Jmac1983** · 09-23-2014, 02:39 PM

I have a 5 column spreadsheet. Column A has 4455 rows of various numbers column B has 6775 various numbers, columns C, D and E contain other data. I want to match column B to column A and align B, C, D and E next to it's matched number in column A and delete the unmatched data from B,C,D and E. Attached is an example spreadsheet. sample excel file.xls

**mrice** · 09-23-2014, 03:25 PM

Please see the attached. I have had to delete some cells to keep the file size down. Copy down the yellow formula cells.

**Jmac1983** · 09-23-2014, 04:38 PM

mrice - I'm not sure what that was. ur sample didn't look anything like what i wanted achieve but thanks for your input. i solved it myself using us vlookup. put this formula in column b to match column a to column c =+VLOOKUP(C2,$A:$A,1,FALSE) then you can filter out the rest manually.