how to return the value of a cell based on two criterias in two columns

D

devdutt_dev

hi,
friends i need help on this one,, please help me..

i have a list in col A which has been categorised as H/W or S/W in co
B

col A col B
laptop h/w
HDD h/w
cdrw hw
Ms Office s/w
Adobe s/w


what needs to be done:

in col C if i put "laptop" then col D should show "h/w"
and if i put "Adobe" or "Ms Office" then col D should show "s/w"

how do i do it..please hel
 
J

JulieD

Hi

further to my reply to your other post
in C1
=IF(B1="h/w",A1,"")
and in D1
=IF(B1="s/w",A1,"")

Cheers
JulieD
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to match 1 value to multiple columns 10
how to place an item in different cells matching two criterias 2
how to return the corresponding value 2
how to return the value of a cell based on two criterias in two columns 2
Increment a number based on four adjoing cells 2
sumproduct return value by comparing two criteria..... 7
Pricing Analysis a bit convoluted 3
how to return the value of a cell based on two criterias in two columns 2

Top