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 formatting excel if and Excel 2003 count unique values if Excel file how to convert numeric value into text value in excel Excel find values that appear more than once Excel if based on date Excel if cell contains any value Excel if font is bold then Excel if sum Excel if text is the same in both tables Excel if then statements Excel sheet if value a in b Excel spreadsheet change time in next cell automatically Excel vba find return false if not found Excel, sum column if value matches a list Nested if values Print multiple values on the same line vba Return a cell content in excel using =if Value of true:10% of sales excel if