Can someone please help me

[stevenmorrison]

im not the best at my formulaes when it comes to excel, im on a trial
period for a I.T company and ive been asked to come up with a formule.

heres my problem, 2 different values in cell a,5014 & 5015, now basic
formula is
if cell A = 5014. L-M.

so the L & M rows which have 5014 in thier row are used in this
calculation, can someone please help me.

as im under a lot of pressure.

 

[Dave O]

Steven-
I *think* you need a VLOOKUP() formula, but I'm not sure. VLOOKUP will
return the value in another cell when it matches the parameters you
provide. Take a look at VLOOKUP in the Help feature, or post more
information.

Good luck!