I will try to simplify this as much as possible. I have been using vlookup, but I don’t know how to make it work with this. Lets say my data has column A which is a country and column B which is its officials. Now with a vlookup if I want to find one official thats easy because it is in the same row as the country, but if I want multiple officials to pop up when I search the country’s name, (like A1: America, B1: Obama, B2: Biden in my data) how do i get it to bring up both Obama and Biden’s name without having to type America in A2 as well.
Share on Facebook Tweet (Share on Twitter) Share on Linkedin Share on Google+ Pin it (Share on Pinterest)