Hi all,
I am looking for a formula that searches the whole page and if it matches a name in my table will then retrieve the informatiom from cell a1, the problem i am getting is that there can be multiple instances of this name which will have different info in cell a1, vlookup wont work, i can get if and match to do it so am thinking of another way bit dont know where to.start.
What sort of formula would search the whole of book 1 and when it matches a name of TABLE1 it returns the value in cell 1, but then when it finds the next name that matches a name in TABLE1 (could be the same as the first) it enters that rows relevent information from cell 1, in the end i want a list of all the names that match a name in TABLE1 and next to those names i want the relevent information in cell 1 of that names corresponding row.
For instance. In TABLE1 i have 3 names John,Jeff and Ted. There is a spreadsheet that logs what dates people worked on but i only want the dates John,Jeff and Ted worked listed, what would that equation be?
hooefully i have explained well and appologise.if.not.
Bookmarks