Replace value with another

I am trying to replace a cell value in column F with another value from my worksheet. There are too many to use find and replace. Is there a way to use Vlookup to do this. I attached my original with a worksheet tab and a expected outcome tab. The full file has almost 5k rows. Another issue I have is some of the replacement values are like 44E8. The 'E' transfers over as scientific notation. I did try the code below but that didn't work due to 44E8 type values. (I borrowed this code from youtube)

Please Login or Register  to view this content.

Give this a try:

Please Login or Register  to view this content.

The code turns cells red if they do not find a solution in the Vlookup. Similar to getting an #n/a when you are doing a formula based vlookup. Lets you know it didn't find an answer.

Cannot replicate your issue of Scientific notation with the sample your provided. Is your actual data different from your sample?

Getting ready to leave for the day. I'll upload a file where the Scientific notations occur tomorrow. The smaller file didn't have those values. Thanks.

Just a quick note. It appears to have pulled all correct data but ALL cells are red.

I don't have a solution for you. I will ask others to try and solve.

Try adding:

Please Login or Register  to view this content.

before the loop.