I have two columns where column A could have repeated text/values and column B have a different corresponding value. Example: Column A has Toronto in rows 1 and 2 but column B has Harry and John in rows 1 and 2. I need a formula that can do a lookup on column A and return John in column B Row 2 if Harry has already been returned from a previous lookup. So the formula needs to return the next valid cell if the result is equal to another cell.
Hope this is clear.
All I have is if(vlookup(B5,sheet!1$A:$B,2,false)=sheet2!C10, and I haven't got any further with anything I have tried.
Let me know if further clarification is required. Any help is appreciated!
Thanks
Bookmarks