I am trying to find a partial string match within a range of cells and then I want to return the data in cells relating to the row that was returned.
Here is the data:-
Name Dept Age Find Value Row Returned
Henry 501 28 Mary 4
Stan 201 19 enr 2
Mary 101 22
Larry 301 29
Row returned is the row number where a partial match is found using this formula - "=MATCH("*"&E2&"*",$A$1:$A$5,0)"
How do I then use this row number to find the other data in the row for the returned match (i.e. for Mary, department 101 and age 22)?
Please help as this is very frustrating...
Bookmarks