So i have strings of concatenated text. I get one value from a worksheet and have it in column A, then I need to look it up and return a value from column B. But when I do the index match it still picks a near match, not the exact match even though i have the Zero in the formula. Can someone please please help!!
Bookmarks