Huge replacement formula

You can create a 2 column table. For the category IDs for example just list all the IDs in one column, e.g. in Y2 down, and in the next column, e.g. Z2 down, you list the description ID. Now for your formula use just

=VLOOKUP(AE2,$Y$2:$Y$50,2,0)

You can do the same thing for your manufacturer IDs

Originally Posted by daddylonglegs

=VLOOKUP(AE2,$Y$2:$Y$50,2,0)

A minor change, it should be $Z$50 instead of $Y$50

=VLOOKUP(AE2,$Y$2:$Z$50,2,0)

Exactly right! my mistake, thanks Haseeb