how to place an item in different cells matching two criterias

[devdutt_dev]

hi,
i need another help....

col A col B col C col D
laptop h/w laptop
Ms Office s/w Ms Office
Adobe s/w Adobe
HDD h/w HDD

col C contains H/W and col D cointains S/W

i need a formulae that would categorise col A based on col B and fee
the data accordingly into col C and col D

thanks,

Devdut

 

[JulieD]

Hi

in col D
=IF(B1="s/w",A1,"")

Cheers
JulieD

 

[Debra Dalgleish]

In cell C2, enter the formula:

=IF(B2="h/w",A2,"")

In cell D2, enter the formula:

=IF(B2="s/w",A2,"")

Copy the formulas down to the last row of data.