Re: $$Excel-Macros$$ Making a mistake in the formula

2016-03-01 Thread GENIUS
Thank you very much for your time -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like

Re: $$Excel-Macros$$ Making a mistake in the formula

2016-03-01 Thread Paul Schreiner
The INDEX() formula syntax is: INDEX(array, row_num, [column_num]) In your formula:=C2-INDEX($E$2:$G$350,MATCH($A2,$E$2:$E$350,0),MATCH($B2,$F$2:$F$350,0))Your second MATCH() function is comparing the value in column "B" (Size) tothe values in column "F" and returns the row number as if it w

$$Excel-Macros$$ Making a mistake in the formula

2016-03-01 Thread Izhar
Please see the attachment, in the file I'm subtracting G2 from C2 with the formula, can anyone tell me where I'm making a mistake Thanks in advance -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ http