Hi all, i have a major problem....went to goggle it and just got confused along the way...
Basically i have 4 columns....Column A is the match involved, Column B is the name of a team and column C contains numbers...I need column D to return the corresponding value in column C if column A contains text in column B, that is, 1.95 in D1...anyone can help please??? Many thanks! Attached the example sheet below...
Bookmarks