Excel Formula

I have a spreadsheet that has a column with specific locations. What I want to do is create a formula that will look at that column and return the cell information only if it matches what I am looking for. In other words, if the column had 1,2,3,4 in individual cells, and I am looking for cells that have 4 in them, then I want it to return a 4 on the same row that the 4 was found. Does that make sense? Example:

a b c d e f <-(result column) 1 X X X 7 X 2 X X X 5 X 3 X X X 2 X 4 X X X 4 X 4 5 X X X 2 X 6 X X X 4 X 4 Thanks