Huge replacement formula

Originally Posted by daddylonglegs

Exactly right! my mistake, thanks Haseeb

You are welcome DDL

Originally Posted by Falcon Punch

Formula used: =VLOOKUP(Master!B2,Brands!A2:B651,2,0)

It's showing values for the first few hundred, but the rest return an #N/A

If you are copying down, you need to lock the table_array range or use whole column reference.

=VLOOKUP(B2,Brands!A$2:B$651,2,0)

Or, whole columns reference

=VLOOKUP(B2,Brands!A:B,2,0)