lookup a value across 15 rows

[NotanExcelGuru]

Here is my problem -

The need to look a certain value say 'desktop' across 15 columns ( 1 row)
and if it is present in any one cell, in the 16th column I need to print
'Desktop'. This data in the rows is what a customer bought on an order, but
the order of the parts in not maintained. Shown in example below

Customer1 desktop server laptop keyboard
Customer2 mouse desktop keyboard laptop
Customer3 server mouse laptop keyboard

I want to come up with

Customer 1 desktop server laptop keyboard
Customer 2 desktop laptop keyboard mouse
Customer 3 server laptop keyboard mouse



Please help, Thank you

 

[dlw]

Use this formula to search the range for the desired item and display it:

=IF(HLOOKUP("desktop",B1:E1,1)="desktop","desktop"," ")

 

[dlw]

Use this formula to search the range for the desired item and display it:

=IF(HLOOKUP("desktop",B1:E1,1)="desktop","desktop"," ")

 

[T. Valko]

Try this:

=IF(COUNTIF(A2:O2,"desktop"),"desktop","")

Or, use a cell to hold the criteria:

P1 = desktop

=IF(COUNTIF($A2:$O2,P1),P1,"")

Then copy across.

 

[T. Valko]

Try this:

=IF(COUNTIF(A2:O2,"desktop"),"desktop","")

Or, use a cell to hold the criteria:

P1 = desktop

=IF(COUNTIF($A2:$O2,P1),P1,"")

Then copy across.