# Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I want a formula (or combination of formulas) to look up the matching values(full name) within one column and based on those matching look in 2nd and 3rd column (email in and email out in last 6mo) and indicate which one is the most/highest. If there is a tie, then look in 4th and 5th column (email in and out in last year). It could be indicated by a yes or number to say that that name.
Solved by E. H. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 07/12/2017 - 03:47
Hello
User 07/12/2017 - 03:47
hi again
Excelchat Expert 07/12/2017 - 03:47
I am sharing the file link with you
Excelchat Expert 07/12/2017 - 03:47
Excelchat Expert 07/12/2017 - 03:48
Excelchat Expert 07/12/2017 - 03:49
User 07/12/2017 - 03:49
Is it possible to send as an excel file?
Excelchat Expert 07/12/2017 - 03:49
yes
Excelchat Expert 07/12/2017 - 03:49
User 07/12/2017 - 03:49
Thank you!
Excelchat Expert 07/12/2017 - 03:56
which version of excel are you using?
User 07/12/2017 - 03:56
2016
Excelchat Expert 07/12/2017 - 03:57
ok
Excelchat Expert 07/12/2017 - 03:57
do you have maxifs function in your excel
Excelchat Expert 07/12/2017 - 03:57
User 07/12/2017 - 03:58
I only see MAX and MAXA. maxifs doesn't comeup
Excelchat Expert 07/12/2017 - 03:58
ok
Excelchat Expert 07/12/2017 - 03:59
my solution includes use of maxifs function
Excelchat Expert 07/12/2017 - 03:59
It won't work on excel
Excelchat Expert 07/12/2017 - 03:59
You can see it on googlesheet only
User 07/12/2017 - 04:01
oh drat. Can maxifs be split in two columns for max and then if?
Excelchat Expert 07/12/2017 - 04:01
It would take a lot of time then
Excelchat Expert 07/12/2017 - 04:02
again
User 07/12/2017 - 04:02
oh... can you give me the formula for a cell?
Excelchat Expert 07/12/2017 - 04:02
I didn't get you
User 07/12/2017 - 04:05
I'm going to try and open the link give me a moment
Excelchat Expert 07/12/2017 - 04:05
ok
User 07/12/2017 - 04:07
Think I'm in
Excelchat Expert 07/12/2017 - 04:07
ok
Excelchat Expert 07/12/2017 - 04:08
See cell K3 to O3
User 07/12/2017 - 04:09
yes
Excelchat Expert 07/12/2017 - 04:09
you have to select emailed contact from dropdown in cell K3
Excelchat Expert 07/12/2017 - 04:09
then O3 will show you the result
Excelchat Expert 07/12/2017 - 04:09
Excelchat Expert 07/12/2017 - 04:09
changing K3
Excelchat Expert 07/12/2017 - 04:09
and see result
User 07/12/2017 - 04:10
Cinthia should have work contact of Ross
Excelchat Expert 07/12/2017 - 04:11
ohh
Excelchat Expert 07/12/2017 - 04:11
User 07/12/2017 - 04:11
Thanks!
Excelchat Expert 07/12/2017 - 04:14
Done
Excelchat Expert 07/12/2017 - 04:14
Excelchat Expert 07/12/2017 - 04:15
there?
Excelchat Expert 07/12/2017 - 04:15
hello?
Excelchat Expert 07/12/2017 - 04:16
Are you there?
User 07/12/2017 - 04:17
Sorry, Yes I'm back
User 07/12/2017 - 04:17
I'll check
User 07/12/2017 - 04:18
This will work for all 4 columns, E-H right?
Excelchat Expert 07/12/2017 - 04:18
yes
User 07/12/2017 - 04:18
Cool!
Excelchat Expert 07/12/2017 - 04:18
you just change the name in K3
Excelchat Expert 07/12/2017 - 04:18
you will get the result in O3
User 07/12/2017 - 04:18
Perfect!
User 07/12/2017 - 04:19
Excelchat Expert 07/12/2017 - 04:19
Welcome
Excelchat Expert 07/12/2017 - 04:19
Excelchat Expert 07/12/2017 - 04:19
Have a great day :)
User 07/12/2017 - 04:19
You too :)
Excelchat Expert 07/12/2017 - 04:19
Excelchat Expert 07/12/2017 - 04:19
You may close the session now from above button.
Excelchat Expert 07/12/2017 - 04:19
BYe :)

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.