CODEWITHSUNDEEP
excelreplacesubstitution
Paul Efford
Paul Efford

Reputation: 265

Substitute strings by references in an Excel sheet

I have a large Excel sheet with lots of repetitive strings in cells, which I need to replace/substitute by a reference:

enter image description here

I have tried so far the Excel function SUBSTITUTE but not managed to make it work... Any idea how to use it properly to achieve my requirement? Thanks in advance

Upvotes: 0

Views: 72

Answers (2)

Paul Efford
Paul Efford

Reputation: 265

Thanks to the hint of @Scott I managed to solve it but using XLOOKUP(A1;D$1:D$3;E$1:E$3), which I find more clear than his proposed solution. Thanks anyway!

Upvotes: 0

Scott Craner
Scott Craner

Reputation: 152505

Use VLOOKUP:

=VLOOKUP(A1,D:E,2,FALSE)

enter image description here

Upvotes: 1

Related Questions