How do I match two cells and input a value in a different cell?
 

A B D E
SRM-260 SRM-260 $7.50
SRM-260S SRM-260S $15.00


Ok, I want to input info in column A and have it look up in D and take the
value that is in E and put it in B.

So if I put in A an SRM-260, I want it to find the SRM-260 in D and input
the value in E that matches the SRM-260 into the B which would be the
$7.50.However if I input SRM-260S in A I want $15.00 to be in B to math the
units.


Can anyone help?


Thanks,

Jason

No pun intended but try doing a lookup in HELP index for VLOOKUP

--
Don Guillett
SalesAid Software

"pensfan" wrote in message
...
A B D E
SRM-260 SRM-260 $7.50
SRM-260S SRM-260S $15.00


Ok, I want to input info in column A and have it look up in D and take the
value that is in E and put it in B.

So if I put in A an SRM-260, I want it to find the SRM-260 in D and input
the value in E that matches the SRM-260 into the B which would be the
$7.50.However if I input SRM-260S in A I want $15.00 to be in B to math
the
units.


Can anyone help?


Thanks,

Jason

Hi
see:
http://www.contextures.com/xlFunctions02.html

--
Regards
Frank Kabel
Frankfurt, Germany


pensfan wrote:
A B D E
SRM-260 SRM-260 $7.50
SRM-260S SRM-260S $15.00


Ok, I want to input info in column A and have it look up in D and
take the value that is in E and put it in B.

So if I put in A an SRM-260, I want it to find the SRM-260 in D and
input the value in E that matches the SRM-260 into the B which would
be the $7.50.However if I input SRM-260S in A I want $15.00 to be in
B to math the units.


Can anyone help?


Thanks,

Jason