Hi,
Need urgent help please peeps.
I have a string of data "BAML - BoA:1999 Baaz Smith - Tradeplant - ETT"
I have a table of names on a different tab.
I need a formula to find above name in my table on a different tab and return back a name. I have below but for some reason its returning a wrong name.
=IFERROR(INDEX(Sheet3!A:A,MAX(IF(ISERROR(FIND(Sheet3!A:A,J2)),-1,1)*(ROW(Sheet3!A:A)-ROW(J2)+1))), "None")
PLEASE HELP!!!
While i am here......how hard would it be to have the reverse......find the name a delete it?
Need urgent help please peeps.
I have a string of data "BAML - BoA:1999 Baaz Smith - Tradeplant - ETT"
I have a table of names on a different tab.
I need a formula to find above name in my table on a different tab and return back a name. I have below but for some reason its returning a wrong name.
=IFERROR(INDEX(Sheet3!A:A,MAX(IF(ISERROR(FIND(Sheet3!A:A,J2)),-1,1)*(ROW(Sheet3!A:A)-ROW(J2)+1))), "None")
PLEASE HELP!!!
While i am here......how hard would it be to have the reverse......find the name a delete it?