Lookup with Duplicate Values
I am trying to cross reference another sheet and return all the values within a column that are state one. In this example, I am trying to get the Jessica Jones, Boba Fett, Mickey Mouse, Bob Saget, Betty White and Meatloaf values returned onto a separate sheet (in separate rows- I do not want these values condensed into the same cell).
Any help would be appreciated! Thanks.
Help Article Resources
Check out the Formula Handbook template!