Recent content by falcon4

understood, thanks, I've resolved the issue. when i added the quotes around the M, NT, and S earlier on, i also redefined my tables. Unfortunately i fixed the formula problem using Skips observation and then created another by having the names using the ranges from the wrong sheets. What an...

Thanks, What I noticed is that the reference column to look at is a concantenation result. Would that make a difference. when i debug it, it just goes to a #N/A. Is there a different way to debug it? I use the show calculation steps to evaluate the formula. I'm not familiar with the Index and...

i've made the correction and get a #NA error. evaluating the expression I get to the point where the second vlookup occurs since the selected variable create a true condition. it is this second expression that creates a #NA result. I don't know why the Vlookup doesn't find the target cell value...

I'm trying to populate certain cells on one sheet using other sheets as a source. I will select from one drop down list a prefix (M, S, NT) this will be the identification of which vlookup function to execute. Each vlookup will have a different named range. The target item number to look for...

Thanks Skip, So far works great, and will save alot of updating time later. Gary

JOB 250 198 212 211 232 233 FPY1 0.8 0.5 1 0.7 0.8 0.9 FPY2 0.3 0.9 0.9 0.7 0.8 0.9 RTY 0.24 0.45 0.9 0.49 0.64 0.81 This data starts in row 11, and Column B (B11 contents is JOB) Row 1 contains some Product line information, nothing that changes on any basis. Likewise down thru to row 11...

this was copied from microsofts site Name Definition Date =OFFSET(Sheet1!$A$1,COUNTA($A:$A)-30,0,30 Price =OFFSET(Sheet1!$B$1,COUNTA($B:$B)-30,0,30) These formulas tell Excel to start at the 30th row from the end of the populated area and create a range encompassing 30 rows and 1...

I'm inserting because i'm creating empty cells to be populated with data collected from the operating floor. it does not exist yet in electronic form until entered by the technician. Inserting allows older data to trailoff the sheet to the right, and still avaialble if needed at a later time...

I have some charts whose values and axis labels comes from cells in 4 rows. (10 cells in each row). I have a macro which will insert a new column of 4 cells, moving the existing cells right. my goal is to have the chart reflect only the most current set of data (10 cells) ignoring the oldest...

thanks again, I have and will continue to brush up on their advantages Gary

i just realized i used the shortened formula "sumprodct" which obviously doesn't work thanks for all the help and the education on this formula, this will work out well, gary

now these work =SUMPRODUCT(--(PROJECT=N14),--(TASK=O14),(HOURS)) or =SUMPRODUCT(--(PROJECT=N14)*--(TASK=O14)*--(HOURS)) i musta pissed off the first buncha formulas somehow

Here are the 2 formulas i tried to evolve from your example =SumProdct(--(H16:H27=$N$14)*--(I16:I27=$O$14)*(J16:J27)) =SumProdct( --(PROJECT= N14) * --(TASK = O14) * --(HOURS)) where i have created names for the ranges. i reviewed the sumproduct description you provided and found it very...

I should clarify one item. While the table i provided shows 4 different task numbers which repeat, in reality there are many more. I would like to return the hours based on selected project, and selected task. I tried the sum product, but that made no sense to me and returned a #name? error...

here is a sample of the data i'll be working thru each month. we have a project name, task number , and reported hours. I'd like to make a formula that allows me to select the project name from a drop down, select the task, again from a drop down, and then have it report the associated hours. i...