Hi,
I've got data in few cell that i want to match.
A:A = names (results)
B:B = Status (match specific)
D:D = Schedule (Match E5)
So in E5 i've got a schedule. Under E5 (e6 e7 etc), i want to Match the schedule in (E5 match in D:D), if a match is found, it needs to match the second criteria in B:B, needs to match "SBK". If both results are found and match, E6 will contain the A:A data (name). And it needs to go to the next row and do the search again for the next name.
I need to be able to reproduce this formula in E6(different schedule) and ++
Is it clear enough?
Bookmarks