Formula to skip a cell if it does not meet criteria

**viciann** · 01-31-2013, 11:57 AM

Hi All,

Hope you can help, I'm a newbie to the site and am learning a lot about formulas.

I already have the below formula to look for '1' or blanks on sheet 1 and pull an item number on on to sheet two.
The item numbers can be on sheet one mutilpe times and i have a formula to identify if they are mark them as 1.

=IF(Invoice!A6="","",IF(Invoice!A6=1,"",Invoice!D6))

Can I add into the formula if 'IF(Invoice!A6=1,' move to A7 and so on down the cells??

Many thanks in advance.

**rcm** · 01-31-2013, 12:21 PM

Could you send a sample both the input and output (no sensitive data is necesary)

**viciann** · 01-31-2013, 12:31 PM

Hi,

Please see attached file that i am using.

**viciann** · 02-06-2013, 05:41 AM

If that cant be done in a formula, can it be done in vba??

**FDibbins** · 02-07-2013, 12:17 AM

Hi and welcome to the forum

I'm a little confused as to what you want. Your tables are blank, it help more if you showed samples of what you are working with, a few examples of your expected outcome, and how you arrived at that?