This picture should explain what I mean:
I want to swap my orders that have IDs into their real names, like the second order table.
For cell A10, then drag down:
=VLOOKUP(Sheet1!A3, Sheet1!$D$3:$E$5, 2)
I think what you want is VLOOKUP. You would use a static list of ID and string value, assign it to a Named region, and then use VLOOKUP to fetch the string for matching IDs.
In cell A9 use the formula:
=VLOOKUP(A2, $D$3:$E$5, 2, false)
5 years ago
4 years ago