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

hi max,
thanks for the help,but i am sorry to inform you that the formulae i
not working

col A col B col C col D
laptop h/w
desktop h/w
HDD h/w
RAM h/w
CPU h/w
Ms office s/w
adobe s/w
acrobat s/w
macromedia s/w

what i want to do is : if i enter any value from col A then it shoul
return the corresponding value in col B in col D

any suggestions???

Thank

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

That's what the suggested VLOOKUP formula does !

I suspect your ref data in *col A*
may also contain leading and/or trailing spaces
that's throwing the matching off with what you input in col C

Try this to clean col A up

Put in E1: =TRIM(A1)
Copy E1 down

Now do a copy of col E and then
select col A and
paste special values ok
over it (col A)

The formula should work fine now
--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <atyahoo<dotcom
----
"devdutt_dev" wrote in message
...

hi max,
thanks for the help,but i am sorry to inform you that the formulae is
not working

col A col B col C col D
laptop h/w
desktop h/w
HDD h/w
RAM h/w
CPU h/w
Ms office s/w
adobe s/w
acrobat s/w
macromedia s/w

what i want to do is : if i enter any value from col A then it should
return the corresponding value in col B in col D

any suggestions???

Thanks


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

If it doesn't work, the problem lies in your data, because based on your
description, it is exactly what you need.

--
Regards,
Tom Ogilvy


"devdutt_dev" wrote in message
...

hi max,
thanks for the help,but i am sorry to inform you that the formulae is
not working

col A col B col C col D
laptop h/w
desktop h/w
HDD h/w
RAM h/w
CPU h/w
Ms office s/w
adobe s/w
acrobat s/w
macromedia s/w

what i want to do is : if i enter any value from col A then it should
return the corresponding value in col B in col D

any suggestions???

Thanks


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