I am creating a quicksearch sheet to compile data. I have tried vlookup, index, match etc, but I am unable to get the result that I want. My problem is that I have a list of people, and for example, let's say I am tracking licence plates and some people have more than one car, and I want to be able to reference the plate no,, color make and model of the car. I can definitely make the list work easily doing vlookup, but I can't make the list bring up more than one line of information.
Solved by B. H. in 22 mins