Filtering one worksheet using another

**Flipper1985** · 03-16-2010, 09:22 AM

Hello,

Thought I'd turn here as my brain is fried.

I'm not very skilled when it comes to Excel.

I have a large list of postcodes for which I require addresses. I have a HUGE list of addresses, covering the postcodes I require and many many more.

How do I rid myself of the many many more and filter the list of addresses to only cover the postcodes I want?

Essentially I have a list of postcodes in worksheet A, and a list of addresses, including postcodes, in worksheet B. I want to filter worksheet B so it only covers the postcodes in worksheet A.

Apologies if this is unclear!

I have a feeling there's a simple solution out there, but I surely can't find it!

Thanks

**Flipper1985** · 03-16-2010, 09:25 AM

Realised there may be some confusion, postcodes are the UK equivalent to zip codes!

**romperstomper** · 03-16-2010, 10:06 AM

Why not just use a lookup on the sheet that has the postcodes you want to retrieve the addresses?

**Flipper1985** · 03-16-2010, 11:14 AM

How do I use a lookup to look up a range of values and not just one?

**romperstomper** · 03-16-2010, 11:23 AM

I'd need more detail to answer that.
If you really do just want to filter sheet B based on sheet A, then add a column to sheet B using a formula like:
=ISNUMBER(match(A2,SheetA!A:A,0))
assuming the postcodes are in column A on both sheets. Then use autofilter on sheet B filtering for TRUE in the new column.

**Flipper1985** · 03-16-2010, 11:38 AM

On sheet A all I have is postcodes, in the one column.

On sheet B, postcodes are in column P, alongside all the other address data (number, street etc).

In sheet B all I want is the addresses for each postcode listed in sheet A.

Hope that makes sense!