I need an excel formula

I will try to explain the best way I can. I am currently using this formula:

=(OR(C6="Complete",C6="Complete - Successful"))+0

It tells me that if the value in C6 is either Complete or Complete - Successful to make it  1, or 100%.

I am wanting to also add to it to check to see if a accounting code matches (Column B on both Sheets), if it does, add the value thats in column K. If not, use the "Complete" or "Complete - Succcessul."

See the attached for an example file. I hope I have explained it well, if not, I will respond asap.
4-27-11.xlsx
LVL 1
wrt1meaAsked:
Who is Participating?
 
zorvek (Kevin Jones)ConsultantCommented:
Use this function:

=IF(ISERROR(MATCH(B2,Survey!B$2:B$1000,0)),(OR(C2="Complete",C2="Complete - Successful")+0),INDEX(Survey!K$2:K$1000,MATCH(B2,Survey!B$2:B$1000,0)))

Kevin
0
 
wrt1meaAuthor Commented:
Works great! Thank you and be on the lookout for future postings.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.