# If statement

#### tlinht

##### New Member
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

### Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

#### Giordano Bruno

##### Well-known Member
Is this any use to start you off?

#### xld

##### Banned
Try this formula

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

#### tlinht

##### New Member
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

##### Banned
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?

Replies
6
Views
247
Replies
7
Views
304
Replies
8
Views
459
Replies
1
Views
219
Replies
28
Views
519

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,163,838
Messages
5,833,921
Members
430,244
Latest member
Ireland1

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back