Formula Question - Value Lookup

[Girish Punjabi]

Hello Everyone,

Pls refer to the following table.

Name apple (y/n) laptop
john y hp
john y lenovo
john y apple
john y sony
john y asus
smith n lenovo
smith n asus
smith n hp


For a name in the "Name" column, if you find the word apple in the "laptop" column, we need to substitute "Y" in "apple(y/n) column for all occurences of that particular name (in the above example "john"). If there is no occurence, we need to subsitute "N". How do we do this using formulae ?

Thanks!
Girish

[FDibbins]

Girish, I have closed your other thread, please do not post duplicate threads. If your thread has not been answered, you need to type "please bump" on that thread, not create another 1

Thanks

[icestationzbra]

if your table ranges from A1 through C9 (including header), then you can put the following formula in B2 and drag-fill down:

Please Login or Register  to view this content.

when i copied your data over, i found that the only instance of "apple" had a trailing space. so, if you don't get a favourable answer at first, check if there are leading / trailing white spaces.