I'm working to replace scattered values is one tab with values mapped in the second tab. The manual process for this is as follows:
select tab 2
select value in column A, row 2
copy value
ctrl+F and paste value into "Find what:" field
expand options and make sure 'Match Case' and 'Match entire...