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