Search one column to return item from another column but in the same row


New Member
Dec 4, 2014
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!

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)


Well-known Member
Jun 7, 2010
Welcome to the board!

I think a VLOOKUP will be your friend. And to my mind the single most important Excel Function!

<b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB"><colgroup><col width="25px" style="background-color: #DAE7F5" /><col /><col /></colgroup><thead><tr style=" background-color: #DAE7F5;text-align: center;color: #161120"><th></th><th>A</th><th>B</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style=";">Abbreviation</td><td style=";">Full</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style=";">A</td><td style=";">Adam</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style=";">B</td><td style=";">Dennise</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style=";">C</td><td style=";">Charlie</td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style=";">D</td><td style=";">Dawn</td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style=";">E</td><td style=";">Edgar</td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style=";">Entry</td><td style=";">Return</td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style=";">C</td><td style=";">Charlie</td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #BBB;border-top:none;text-align: center;background-color: #DAE7F5;color: #161120">Sheet1</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #BBB"><thead><tr style=" background-color: #DAE7F5;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B9</th><td style="text-align:left">=VLOOKUP(<font color="Blue">A9, $A$2:$B$6, 2, FALSE</font>)</td></tr></tbody></table></td></tr></table><br />

Hope that helps.

Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Latest member

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back