IF statement help needed

V

vanderpool

I have 2 sheets who's data must match. Titles are as below in sheet1 and
sheet2

NAME HOURS PAY JOBTITLE NETSALES GROSSSALES

Alot of the time the data doesn't match exactly, but comes close, ie
the name will be spelled incorrectly. Sheet2 will be in a DIFFERENT
ORDER as well, ie the names will be out of order, than sheet1 and I
need to make another sheet that will show if there are any mismatched
data.

I have tried an if formula like

=IF(Sheet2!A1=Sheet1!A1,"MATCH",Sheet2!A1 &" | "&Sheet1!A1)

which will return the values separated by | as long as A1 in each sheet
is the right person, then i can manually sort through and make changes.


However, this does not work as i need it to search through the entire
column of sheet2 NAME for a closest match and then input all the
contents of the NAME HOURS PAY JOBTITLE NETSALES GROSSSALES in a new
sheet so I can compare the data. Hope that made sense... hehe

oh yea, I think I may need to use a IF(ISNA(MATCH formula, but have no
clue if that is the right direction to go....?
:confused:
 
F

Frank Kabel

Hi
for exact name matches you could use VLOOKUP or an
INDEX/MATCH combination. If you need a kind of 'fuzzy'
match it will become more complicated. Any chance that at
least the beginning of all names is equal?
 
V

vanderpool

Yea, I saw a post on that VB fuzzylogic thing, not sure how to use it
though. Has anyone used it before, and if so, how would I go about
adding it to my workbook?
 
Top