I am breaking down a funds return by industry. I need to write some code to get cells below the industry name to search in another sheet and bring in all the security names in a specific column that are in the industry. I could do lookups , but i dont want blank spaces for the ones that arent in the industry. I basically need code to say

if range("a1:a60") = B1 (B1 being a cell with industry name and range being list of all industries in portfolio)
Then give me the corresponding security name in Range("C1:C60")
else continue on until one is found put that in cell D1
then i need it to continue searching until theyre all found
end


Please let me know if you know of something that will work

Thanks in advance,

Tim