linking data based on multiple criteria using if and

[loftsman325]

i need to check if multiple criteria is met: ex formula=IF(AND('NAPTHA FINAL'!D10>0,'NAPTHA FINAL'!J10>0,'NAPTHA FINAL'!L10<0),'NAPTHA FINAL'!A10," ")

but i need the formula to go through every row to see if this is true and return the result to that line when true and continue to loop through inputing the data to the next line every time the condition is met.
is this possible through a function?

 

[Aladin Akyurek]

Why don't you copy down that formula?

 

[T. Valko]

i need to check if multiple criteria is met: ex formula=IF(AND('NAPTHA FINAL'!D10>0,'NAPTHA FINAL'!J10>0,'NAPTHA FINAL'!L10<0),'NAPTHA FINAL'!A10," ")

but i need the formula to go through every row to see if this is true and return the result to that line when true and continue to loop through inputing the data to the next line every time the condition is met.
is this possible through a function?

Just copy the formula down the column.

Also, you should change the value_if_false argument to return a blank rather than a space character:

=IF(AND('NAPTHA FINAL'!D10>0,'NAPTHA FINAL'!J10>0,'NAPTHA FINAL'!L10<0),'NAPTHA FINAL'!A10,"")

 

[loftsman325]

well I guess the reason is because i was hoping to only return true values and if false to run the query on the next line

i will word it best way i can
if sheet 1 d10,j10,l10 = true
then place sheet1 a10 in a10 sheet 2
if sheet 1 d10,j10,l10= false
then run query for d11,j11,l11 if true place d11 in d10
and continue to run down the list until it has searched all data and moved all criteria that matches to sheet 2

 

[T. Valko]

well I guess the reason is because i was hoping to only return true values and if false to run the query on the next line

i will word it best way i can
if sheet 1 d10,j10,l10 = true
then place sheet1 a10 in a10 sheet 2
if sheet 1 d10,j10,l10= false
then run query for d11,j11,l11 if true place d11 in d10
and continue to run down the list until it has searched all data and moved all criteria that matches to sheet 2

Sorry, but I'm not following this.

 

[loftsman325]

ok if use the formula i have and copy it down it would result in blank rows. i only want it link the data that returns a true value to fill the sheet. Does this make sense?

 

[T. Valko]

ok if use the formula i have and copy it down it would result in blank rows. i only want it link the data that returns a true value to fill the sheet. Does this make sense?

OK, so you want to extract data that meets conditions.

I get that part. What's confusing (to me) is that in your example you wanted to extract the value of cell A10 based on data in row 10 but then you wanted to extract the value of cell D10 based on data in row 11.

If you can give us a clear description of where the data is and what the conditions are we can probably come up with something to get this done.

How many rows of data are to be searched? If there are 1000's then a formula would probably not be the best method to use.