I am attempting to lookup, match, and then fill in data from one worksheet to another. For example, in the Data Scrub tab, I need to select the first entry "NCR CORPORATION', see if there is a close (fuzzy?) match in the 'EXTRACT' tab. Ah! There is! NCR CORPORATION-CHRS
" is the closest match. Then I need to copy that (NCR CORPORATION-CHRS) and paste it into A2 in the 'Data Scrub' tab..lastly, I need to copy the Tier number from D18 on the 'Extract' tab and paste it into C3 on the 'Data Scrub' tab (and color it RED if possible, or mark it someway to note that it's changed)
I hope my explanation was clear. I understand the 'fuzziness' of matching may be an issue?