Freeze(F4) the data as per their type

[uroy67640]

Hi,

I want to segregate the data by their type. In A column of attached file is linked with B column data. In cell ref. A4 it is linked with B4 but as per the type of fund it has to be change. I have also freeze the data as per the fund type. I did it manually and I am also highlight the changes where its needed. Is it possible to customize a formula to do same thing.


Regards,
Uday

[daffodil11]

=LOOKUP(2,1/ISNUMBER(SEARCH("Fund",$B$4:B4)),$B$4:B4) and copy down