Can someone please help me
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. -- stevenmorrison ------------------------------------------------------------------------ stevenmorrison's Profile: http://www.excelforum.com/member.php...o&userid=26188 View this thread: http://www.excelforum.com/showthread...hreadid=394971 |
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! |
All times are GMT +1. The time now is 01:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com