Find and extract from multiple columns

[luis_marques]

Hi,

I need to find in which column at symbol (@) is and extract the all the value from the respective cell.

Example:

 

[Hui]

Luis

Can you please attach a sample file with the data and an example of the final layout you require

 

[bosco_yip]

Try,

In G1, formula copy down :

=INDEX(A1:E1,MATCH("*@*",A1:E1,0))

or,

=LOOKUP(2,1/SEARCH("@",A1:E1),A1:E1)

Regards

 

[luis_marques]

Hi Hui, i attached a file with data and desirable extraction in two sheets.

 

[luis_marques]

Thanks bosco_yip. It worked well.

 

[Khalid NGO]

Hi,

One more with HLOOKUP:

=HLOOKUP("*@*",A1:E1,1,0)

Regards,

 

[luis_marques]

Hi,

One more with HLOOKUP:

=HLOOKUP("*@*",A1:E1,1,0)

Regards,

Thanks Khalid.