Hello,

I am trying to write code that will search for a specific data, such as a part # and then write another set of fixed data into the adjacent cell. For instance, if:

If A:1 = "ABC" then B:1 = "abc123"
If C:3 = "BCD" then D:3 = "bcd234"

-Where"ABC" and "BCD" would be part #'s, and "abc123" and "bcd234" could be a description, vender #, etc.

I would prefer that the logic would work no matter what column the part # is in.

In other words, I am trying to automatically fill in the description/other info whenever a user of the application enters a part #.

Thanks in advance,

James