If statement

tlinht

New Member
Joined
Aug 11, 2010
Messages
14
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

xld

Banned
Joined
Feb 8, 2003
Messages
5,378
Try this formula

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

tlinht

New Member
Joined
Aug 11, 2010
Messages
14
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
Joined
Feb 8, 2003
Messages
5,378
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?
 
Master Excel Bundle

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.

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top