If criteria met, insert name

[Godders199]

Hello, currently i use the following formula, which returns 1, if the criteria is met. Which has has worked fine.

=COUNTIFS('HFC '!H:H,Submissions!A2,'HFC '!I:I,"match",'HFC '!J:J,"")

this formula is in column P on the submissions tab.

However, I now need it to return the name in column c of the HFC tab where the crtieria is met instead of 1.

WOuld someone be able to help me on how i need to change this formula to pull the name from column c .

Thanks

 

[Marcílio_Lobão]

Godders199, Good afternoon.

I'm not right if I understood well your necessity.

Try to use:

=IF( COUNTIFS('HFC '!H:H,Submissions!A2,'HFC '!I:I,"match",'HFC '!J:J,"") =1,'HFC '!C2,"")

Is it what you're looking for?
I hope it helps.

 

[Godders199]

Thanks for your reply. not quite what i am looking for, this formula just brings through the name from the cell the last part of the formula is looking for , so if the criteria is met it will just bring forward what ever the value is in HFC c2 for example, not the name on which the criteria is met.

think its more of a if crtieria met, then vlookup or match formula.

For example, if row 10 on the HFC tab, meets the criteria of row 2 on the submissions tab ( where the formula is) , whatever the name is in C10 is the value that needs to be returned to P2 on the submissions tab.

 

[Marcílio_Lobão]

Godders199, Good morning.

Try to save your file at a free site, www.sendspace.com and put a link to download here.

It'll save time and effort from us to help you.

Having access to the file is faster and more people are there to help resolve the question.

Have a nice day!