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

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

--
devdutt_de
-----------------------------------------------------------------------
devdutt_dev's Profile: http://www.excelforum.com/member.php...fo&userid=1218
View this thread: http://www.excelforum.com/showthread.php?threadid=26533

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

One way:

Assuming the reference list is in cols A and B,
data in row1 down

Put in D1: =VLOOKUP(TRIM(C1),A:B,2,0)
Copy down

--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <atyahoo<dotcom
----
"devdutt_dev" wrote in message
...

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 col
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 help


--
devdutt_dev
------------------------------------------------------------------------
devdutt_dev's Profile:
http://www.excelforum.com/member.php...o&userid=12184
View this thread: http://www.excelforum.com/showthread...hreadid=265338

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

=vlookup(C1,A:B,2,False)

--
Regards,
Tom Ogilvy

"devdutt_dev" wrote in message
...

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 col
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 help


--
devdutt_dev
------------------------------------------------------------------------
devdutt_dev's Profile:
http://www.excelforum.com/member.php...o&userid=12184
View this thread: http://www.excelforum.com/showthread...hreadid=265338