I am trying to return the position name from Data 2 sheet into Data 1 - the condition is if the ID in Data 1 match ID in Data 2 and DOJ in Data 1 match DOJ in Data 2 - return the position name.
try to use index-match function, but it retun error ...
help please![]()
Bookmarks