Tell me more ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.
up vote 0 down vote favorite

This picture should explain what I mean:

alt text

I want to swap my orders that have IDs into their real names, like the second order table.

share|improve this question
So do you mean A, D and E? – Lance Roberts Dec 7 '10 at 6:06
Yes in the image, the title was generic. – FlavorOfLife Dec 7 '10 at 6:12
What is your question? Can you please clarify in small words that I can understand? – Randolph West Dec 7 '10 at 6:25
I've edited the picture, it should make more sense now. – FlavorOfLife Dec 7 '10 at 7:02
Well that makes a difference, you need to reference the sheets, I've edited my answer. – Lance Roberts Dec 7 '10 at 8:37

3 Answers

up vote 0 down vote accepted

For cell A10, then drag down:

=VLOOKUP(Sheet1!A3, Sheet1!$D$3:$E$5, 2)
share|improve this answer
Odd, I've entered this, nothing returns. I have to note that the cell format is just plain text. – FlavorOfLife Dec 7 '10 at 6:39
@Flavor, so what does it show in the cell, completely nothing? – Lance Roberts Dec 7 '10 at 6:42
No, just the formula – FlavorOfLife Dec 7 '10 at 6:46
@Flavor, that happens to me when I forget the '=' sign. Though maybe you have calculation turned off (if so then hit 'F9'). – Lance Roberts Dec 7 '10 at 6:47
Not having much luck still. But I've edited the picture, can you explain or link me how vlookup works? – FlavorOfLife Dec 7 '10 at 7:00
show 1 more comment
up vote 0 down vote

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.

share|improve this answer
up vote 0 down vote

In cell A9 use the formula:

=VLOOKUP(A2, $D$3:$E$5, 2, false)
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.