Excel 2007 : How to find a text within cells and...

[frecz1]

Hello there!

I1ve got a problem which seems difficult to me.

Let's say i've got places of recycling bins such pubs,shops etc. in column A. I've got results each week in column B,C,D and E which shows how many material collected from each places. I've got this for every week since January. I've got another sheet which shows which place belongs to which specific council. But then i often need to change the order of the places because sometimes we need to remove them or place a new recycling bin.

Sheet1 contains places in column A, result column B,C,D,E
Sheet2 contains places in Column A, which council column B

So i want to search Sheet2ColumnA1 within Sheet1ColumnA1:A300 and get the result Sheet2ColumnB1.

The problem is that they are all mixed up. I hope you understood!

Thanks for Help!

[frecz1]

Finally found it pretty simple thanks anyway