Hi All - I tried doing this yesterday but am doing a different spin on this today to hopefully get an answer...

I would appreciate it if someone could help me with a macro that would search for an inputted state in $h$2 and automatically output all the chains that are in that state in k:k


Please help!

Thank you

LookUp Macro Help 8.13.13.xlsx