joshscott12
New Member
- Joined
- Dec 4, 2014
- Messages
- 2
Excel novice here, but I'll try to explain what I'm trying to do as clearly as possible.
I have two columns of information, and I want to create a cell that will allow me to search the first column and then return the element that is in the next column, but in the same row.
To explain further: the first column is a list of abbreviations and the second is the list of items that those abbreviations stand for. I want to be able to type the abbreviation in a seperate cell on the page that will then search through the list of abbreviations and have excel return (in another cell, of course) the full name from the second column.
Example: If "CAP" is in A23, I want to be able to search "CAP" (in some arbitrary cell on the page) and have the full name return from cell B23, since the abbreviation is right next to the full name.
I hope that makes sense, but I'll gladly try to explain further if it doesn't.
Thanks in advance for the help!
I have two columns of information, and I want to create a cell that will allow me to search the first column and then return the element that is in the next column, but in the same row.
To explain further: the first column is a list of abbreviations and the second is the list of items that those abbreviations stand for. I want to be able to type the abbreviation in a seperate cell on the page that will then search through the list of abbreviations and have excel return (in another cell, of course) the full name from the second column.
Example: If "CAP" is in A23, I want to be able to search "CAP" (in some arbitrary cell on the page) and have the full name return from cell B23, since the abbreviation is right next to the full name.
I hope that makes sense, but I'll gladly try to explain further if it doesn't.
Thanks in advance for the help!
