I have a massive table in one sheet in Excel and I want to take the relevant
information from it onto other sheets. Basically, I want a formula that will
look down a column until it finds an entry, then take this entry and put it
into another sheet, along with the other information in the same row, then
find the next entry etc etc. Which function would I use to do this? I've
tried looking at vlookup but I'm not sure that's what I want..