Having issue trying to get a specific value to populate in another cell

I am trying to read a column and then if value "Support" is present column I want to display the value in a different column on the same row.

=IF(('ETC ForeCast'!F2:F75)="Support",'ETC ForeCast'!C2:C75,"No Incidents named Support")

Now I can get this to work if I don't include the range at the beginning and I just look at one cell. Also I am running into the issue that I am looking at a column with 75 different cells that I am looking at, So it is possible that I could have to display 75 results. Now I know I cannot display 75 results on one cell. I need to be able to push the next result down to the next cell below and so one and so on. Also I have noticed that if I put this in to Cell A19 on my test sheet this will work because the VALUE I am looking for just so happens to be in row 19 on the data sheet. I am a noob when it comes to this stuff so I am sure I just done understand.

This might be a better description.
Column A has numbers(incident number). Column F has descriptions of the incident . A possible description could be "Support" I want to know what incident number has the Support description on my dashboard I created.



Any suggestions

Hi defilted,

Please see the forum rules and update your thread title.

Jonmo1, this formula does work and will display the correct incident number for the first "Support" it finds. Thank you! My next questions is how would I get it to display the next one is finds as well. So I changed my data set to have 2 rows that contain the "Support" value and I still get only the first one. I would like the formula to auto populate the next cell down with the next "Support" is finds..

Glad to help.

As far as the criteria, that's a whole other ball game.
As you can see, Match will only find the first matching value it finds.

I think it's possible to do what you want, but it's not exactly easy..

Maybe this will help
http://www.myonlinetraininghub.com/e...ltiple-matches


@Mods, the title has been changed at the time I made this post.