mark matches between colums

**legolas** · 02-10-2010, 08:33 AM

Dear all,

I have a file attached showing in a, b and c the actual traveler data
and i have in d, e and f his authorized data of travel

i am trying to create a match so that, if data is the same in d,e,f as in a,b,c then any mark can be placed in g.

the data does not need to match %100, as long as id and name has anything similar on that date then this will do.

I hope i made the idea clear and any help is appreciated

thank you

**teylyn** · 02-10-2010, 05:04 PM

Hi legolas,

maybe something like this in G2 and copied down

=IF(AND(NOT(ISERROR(SEARCH(LEFT(D2,3),A2))),NOT(ISERROR(SEARCH(E2,B2))),F2=C2),"OK","no match")

**legolas** · 02-22-2010, 04:20 AM

thanks tylyn
it will match if data is in the same row
what if g2 had a match data in row 6 or 7 or going down throgh the sheet ! will it be found ?
thanks

**teylyn** · 02-22-2010, 06:38 AM

That would require some kind of fuzzy search that can only be accomplished with VBA, AFAIC. At which point I must pass.

Maybe it would be easier to install some kind of data validation when the Name authorized and ID authorized are entered, so all this trouble can be avoided.