Scripting dictionary name replacer

[Luke777]

Hi,

I'm sure I asked a similar question a couple of years ago, but I don't seem to be able to find the post.

Basically, on Sheet1 I have product names in column B. On sheet 2, I have the same product names in Column A and product codes in B. I would like to replace the names on Sheet 1 with product codes. I've already handled errors before this stage (name on Sheet1 with no reference on sheet2, prompting user intervention).

I'm sure this is doable by chucking the 'index' (sheet2) in a dictionary and then going through Sheet 1 A, but it's a bit beyond my ability to recall the method

Thanks

 

[jkpieterse]

Can't you just use a formula (XLOOKUP) to pull the product codes into Sheet1 and then copy/paste Values them on top of those names?

 

[Luke777]

Can't you just use a formula (XLOOKUP) to pull the product codes into Sheet1 and then copy/paste Values them on top of those names?

I could do, but this is taking place in the middle of a load of other code that cleans and transforms the data at the press of a button - I'd sooner keep it all within VBA... though I guess I could use VBA to handle the formula?