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)
Sign up using Google
Sign up using Facebook
Sign up using Stack Exchange
4 years ago
3 years ago