Help: Hlookup against multiple array display closest match

Hi. I have been working on matching inexact data for about a month and ran into something that stumped me.

I used a Fuzzy lookup to match the data that was shared between my two tables. I was able to run 3 different Fuzzy attempts to increase my accuracy because the source data had a lot of spelling errors and such.

Now I am at a point where I need to analyze the 3 possible Fuzzy matches. I am kinda stumped on the best route to do this and thought that an approximate match Hlookup would be the best route but I can't seem to get it to work.

Here is a pic of my table: http://i.imgur.com/BmD0B.jpg

I am trying to match the cell outlined in red against the 3 cells outlined in green, when the best suited match is found I need to copy the green cell and the orange adjacent cells to it's left and right (ID# and Similarity). It would be best if the match threshold was in the low 90% range.

Any help would be greatly appreciated!

"pics" are DEFINITELY not the best way to get answers...a sample WorkBook would help a lot more..

May be this...

Formula:

Please Login or Register  to view this content.

Is there anyone way to have it copy the cell S2?

Not sure what do you mean in the above sentence

try this...
=if(COUNTIF(T2:X2,S2)=COLUMNS(T2:X2),S2,"")

Originally Posted by LightingPop

Like when the =COUNTIF(T2:X2,S2)=COLUMNS(T2:X2) formula finds a cell

I am not aware how the S2 cell is getting the input. Whether it is manually entered? or arrived by any formula used in the S2 cell?

Do right click on the sheet Tab and select view code and copy and paste any one of the below code which suits for you based on the method of S2 cell value change...

If S2 cell is manual entry then use this one

Please Login or Register  to view this content.

If it is arrived by the formula used in S2 cell then use the below code

Please Login or Register  to view this content.

Match If 2 of 6 cell have S2

Again I am not clear about the above statement

Match should happen in which range? and T2 to X2 its only 5 cells then how you are getting 6?

Change this line

If bMatchCount = bColCount Then Range("S2").Copy

To

Formula:

Please Login or Register  to view this content.

Yes you wont get it there, since it is a sheet event code so it will trigger automatically when there is any change in S2 cell or if S2 value is arrived via formula then on calculation of the sheet the code will trigger automatically.
So the code requires any of the above based on the method you used.

Sent from mobile device

Yes its possible and the code needs to be altered. but at present I dont have access to computer and posting replies from my mobile device.

I will post my reply tomorrow that is after 12 hours time, if you dont get any solution.

Regret for the inconvenience

Is there anyway to make it so I have to run the code in it just runs down the length of the sheet checking for matches the whole way down?

Ok... based on your above new requirement please explain what action to be performed when looping through each cells of column-s.