Re: $$Excel-Macros$$ I've inherited a formula I don't fully understand

2016-07-25 Thread Ron Hornsby
Great explanation: thanks > > -- 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 Plea

Re: $$Excel-Macros$$ I've inherited a formula I don't fully understand

2016-07-25 Thread Paul Schreiner
In this case, DATAPAGE is a named range in your workbook. You can try to find it by looking in the pull-down above the column headings:  or look in our Name Manager on the Formulas tab: Either should show you where this ranged is defined. Paul- “Do all the g

$$Excel-Macros$$ I've inherited a formula I don't fully understand

2016-07-25 Thread Ron Hornsby
=IF(($A3=0),"",(IF(VLOOKUP($A3,DATAPAGE,3)=),"",(VLOOKUP($A3,DATAPAGE,3) It's the "DATAPAGE" I've never incountered. (there are no tabs that I see with that name) Anyone explain how it's used? The sheet it is in has started populating wrong information. -- Are you =EXP(E:RT) or =NOT(EXP(