Quote:
Originally Posted by Weitz
I have a question:
I have a list of items that I need to assign a value to. They are labeled 1-6 with each number having a different value.
Is there a formula to use some sort of "If equal to 1 (or 2 or 3 etc) than show the corresponding value for 1 or 2 or 3 etc"? I can't seem to figure it out.
|
Make another list somewhere. Use VLOOKUP
Example, I have A1:B6
1 AAA
2 BBB
3 CCC
4 DDD
5 EEE
6 FFF
My data is from column D onwards, where D is 1-6 in random assortments.
So if I want the corresponding values to show up, I have in box C1:
=VLOOKUP(D1,$A$1:$B$6,2,FALSE)
What it's doing: Take the value in D1, find it in column 1 of A1:B6, return the value in column 2 of that array (column B). False means exact match only. The $ allows you to drag it down all of column C
https://support.office.com/en-us/art...8-93a18ad188a1