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... :/