You can start the spreadsheet whereever you want, but it would make
sense if the formula was on the same row for obvious reasons

=IF(ISNA(VLOOKUP(A1,$C$1:$D$1000,2,FALSE)),A1,VLOO
KUP(A1,$C$1:$D$1000,2,FALSE))

so the above formua would go on row1

if it was row 2 change a1 to a2

It can be copied down andwill adjust once you put the first formula in
correctly

somwhere you need a list of your autocorrect option,in my example they
are in c1:d1000, this may need to be a bigger or smaller range, but you
can adjust that

c1 contains the error and d1 its correction
c2 contains the next error and d2 its correction etc


So in your example
HDWDM should be in column c with Hardware in column d but the same row

the vlookup looks up the value in a1 finds it in c1:c1000 and then
returns the value in the column tothe right(d), thats what the 2 means.
the false means an exact match has to me made

however not everything will need autocorrecting, some values will be
correct, in that case the lookup will fail and return #n/a in this
instance stick with the original value in cell A1

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=561375