I am trying to use formula to match two columns
It works in the first 2 rows but not after row 2
spreadsheet attached
appreciate any help
Carroll
I am trying to use formula to match two columns
It works in the first 2 rows but not after row 2
spreadsheet attached
appreciate any help
Carroll
Put this on AF6 and copied down:
=IFERROR(IF(IFERROR(LOOKUP(1000,SEARCH(SUBSTITUTE($AB$6:$AB$11," ","*"),L6),$AB$6:$AB$11),LOOKUP(1000,SEARCH(LEFT($AB$6:$AB$11,FIND(" ",$AB$6:$AB$11&" ")-1),L6),$AB$6:$AB$11))=IFERROR(LOOKUP(1000,SEARCH(SUBSTITUTE($AB$6:$AB$11," ","*"),L6),$AB$6:$AB$11),LOOKUP(1000,SEARCH(LEFT($AB$6:$AB$11,FIND(" ",$AB$6:$AB$11&" ")-1),L6),$AB$6:$AB$11)),"L matches AB","No Match"),"No Macth")
Azumi,
Thanks so much for the formula
It works great.
Carroll
Azumi
One question - What does the 1000 do in the formula. I know how to change the range, such as row 6 - 11
but not sure if I need to change the 1000 if I have a sheet with 4000 rows of data.
Thanks Carroll
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks