I'm a newbie, so please bear with me.
I need to compare two cells and place a "1" in the cell that matches.
$j$2 contains the text I want to match i.e. "62 Years 4 Months"
Cells I4:I358 contains all the "Years, Months, and days" values I want to lookup i.e. "62 Years 4 Months 3 Days"
I need to select the partial text that matches $J$2 . When a match is found, I need to place a "1" in the cell.
I tried Vlookup($J$2&"*",$I4:$I358,1,false)
=index($I$4:$I$358,match($J$2,1)
No luck - Any help would be appreciated
Bookmarks