How do I filter rows on excel sheet based on another sheet

Hi,

I have two catalog sheets based on SKU (product id number) I also have another worksheet with some of these. How do I filter rows from the first one based on the skus from the second one.

thanks
jecommeraAsked:
Who is Participating?
 
Rory ArchibaldConnect With a Mentor Commented:
Add a new column to worksheet2 using a formula like:
=INDEX(Sheet1!B:B,match(A2,Sheet1!A:A,0))=""

and then filter sheet2 using that column and filtering for TRUE values.
0
 
Rory ArchibaldCommented:
Sounds like you need an Advanced Filter using formulaic criteria. Can you post a sample showing the actual layout of the two?
0
 
jecommeraAuthor Commented:
worksheet1

<id><value1>

worksheet2

<id><row>

So I need list of worksheet2 rows where same id in worksheet1 and value1=<null>

thanks
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
Rory ArchibaldCommented:
That's not enough info really. Can you post a small sample showing what you have and exactly what output you expect.
From what you've said it looks more like a lookup formula than any sort of filter currently.
0
 
jecommeraAuthor Commented:
ID                      IMAGE_original_1
30004910      image.jpg
30004911

ID                     name
30004910      cap
30004911        jumper


      


0
 
Rory ArchibaldCommented:
When I say sample, I mean a sample workbook, so I can see what you want as the outcome. At the moment I'm thinking you just want a formula in the first sheet like this in C2:
=IF(B2<>"",IF(ISNA(MATCH(A2,Sheet2!$A:$A,0)),"",VLOOKUP(A2,Sheet2!$A:$B,2,False)),"")
0
 
jecommeraAuthor Commented:
Sorry I cannot post the worksheet as it contains some private data.

I dont want a value in a cell.

I need rows from worksheet2 where the same ID in worksheet1 does not have an image (i.e. the value in the second column of the row is null
0
 
jecommeraAuthor Commented:
also all the data in worksheet2 is contained in worksheet2
0
 
jecommeraAuthor Commented:
woops also all the data in worksheet2 is contained in worksheet1
0
 
jecommeraAuthor Commented:
Great Work !!!

thanks for your help
0
 
Rory ArchibaldCommented:
Glad to help. :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.