Search for specific value in a row, then return content og adjacent cell

**linaudio** · 03-18-2013, 05:14 PM

Hi everyone, I have a spreadsheet with company names and contact info. The only problem is the layout. Slightly simplified, it looks like this:

A B C D E
1 Acme Industries Email [email protected] Address Fantasy street 5
2 Europe Industries Adress Somestreet 3 Fax 12345678

So you see, one row contains all info about a certain company, and the order is not the same for every row. What I would like to achieve is to add a formula in for example F1, that searches for "Email" on row 1, and then returns the value of the cell one step to the right of where "Email" is found, in this case the email address [email protected].

Is this possible to do with a formula? I'm hoping to avoid any vba... :/

**alansidman** · 03-18-2013, 05:47 PM

This could probably be done with a series of nested if statements. What is the maximum number of columns that your spreadsheet has this data in. Perhaps a copy of your spreadsheet uploaded with enough samples to different presentations of data to ensure we capture all scenarios.