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

[devdutt_dev]

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

 

[Max]

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

 

[Tom Ogilvy]

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