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