Hello,
I'm needing some assistance with the following scenario:
I have two sheets in one excel document. I need to pull a parts description from sheet 2 to sheet 1 only if sheet 2's part description has a numeric value for that part in a different cell on the same row. I am using the =If(IsNumber.. formula and it works in pasting the values.
What I need is to know if the IsNumber is false, how do I move to the next line to check for a true value? In other words, I don't want to populate sheet 1 with a value unless it is a true statement. I want to consolidate my parts list onto sheet 1 by referencing the numeric value for that part on sheet 2.
Here is the formula I have with the ? denoting the area I don't know. Seems I need a statement that will force the formula to try the next line but still paste into the original sheet1 cell until a value is returned true and then move to the next line.
=IF(ISNUMBER('Sheet2'!G4:G46), 'Sheet2'!C4:C46, ?)
Help?
-Austin
Configuration: Microsoft Excel 2007
Conditional format 2003 excel if cell equals formula examples Excel find value between 2 values Excel find value within cell Excel formula if value is between value and value Excel get value from external worksheet Excel if cell change force refresh Excel if false Excel if value exists then show other value Excel if value less than x make x Excel if value then color Excel if value then display text Excel vba value wild card If statement excel if value is equal to cell value In excel check if value in one sheet is the same in another sheet Insert row in excel when values changes Macro excel if value = 0 goto end Ms excel if less than and greater than Vba excel if font color =