I am relatively new to using excel and I have a problem. I have a list of data in several columns and rows, say a1:e:10. I have a drop down menu to choose a piece of information out of the data. Vlookup will spit out the data that I request, but there are cases were the item I choose from the drop down list is in my data more than one time. It seems like vlookup just gives the first one that it gets to. I need something that will retrieve more than one item if there are multiple entries of that item. thanks.