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