If statement

[tlinht]

I need a formula that would list multiple occurrances if a single criteria is met. In most instances, there will be more than one. Was wondering if this something like this would work:


if F8:F38=15, and F11 happens to equal 15, then return A15...or if F20 also equals 15, return A20, etc, or if there 15 doesn't occur in in F8:F38, for it to remain blank instead of returning #N/A error message.....essentially that is all I need it to do

 

[Giordano Bruno]

Is this any use to start you off?
=IF(ISERROR(MATCH(14,F8:F38,0)),"Not Found","Found")

 

[xld]

Try this formula

=IF(F15=15,A15,IF(F20=15,A20,IF(NOT(ISERROR(MATCH(15,F8:F38,0))),"Found","")))

 

[tlinht]

Well its not a given that f15 is going to equal 15, I was just using that as an example. So would something like this work?

=IF(F8:F38=15,A8:A38,IF(NOT(ISERROR(MATCH(15,F8:F38,0)))

And also I tried incorporating index and match into a formula before but the problem I kept running into was that match only returned one match when there others as well

 

[xld]

Well its not a given that f15 is going to equal 15, I was just using that as an example. So would something like this work?

=IF(F8:F38=15,A8:A38,IF(NOT(ISERROR(MATCH(15,F8:F38,0)))

And also I tried incorporating index and match into a formula before but the problem I kept running into was that match only returned one match when there others as well

Mine allows for it to be other than 15, so what is wrong there?