look up multiple values

Hi all, I've been stuck for a couple of days trying to get a dropdown box to do what I want it to do - to no avail. I have four products A, B, C, D that are dependent on a mixture of 9 components and I would like to sort their dependency using a dropdown box. like: A B C D 1 x x x 2 x...

I am trying to delete rows that A:A does not match a list on another tab. I know I can do a add column, the vlookup, then delete the empty rows but I am trying to do it a cleaner way.

Hello! I'm using the following function to lookup a value based on two conditions. It works perfectly if I try to find only one value. However, I would like it to give me a range of corresponding values if there are more than one. Does anybody here know how I could do so? I didn't invent...

Hello! I'm using the following function to lookup a value based on two conditions. It works perfectly if I try to find only one value. However, I would like it to give me a range of corresponding values if there are more than one. Does anybody here know how I could do so? I didn't invent...

Hi, I am looking to build a VBA to do the following action: Look up an ID number from column F (ID numbers are separated by an empty row at current), then check whether there is a corresponding value in columns N to P, if there are values, copy them onto a different sheet into three...