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