#VALUE! Error What wrong with formula

='Sheet1!A2:A5000=A5,'Sheet1!$G$2:$G$5000<>""+90

On sheet1 Column A list names & Column G list current dates. On sheet 2 I want to list a closing date by names. Closing dates are 90 dates from current date. I used the above formula and got a #VALUE! error message.

A5 = a person's name (which is located on sheet 2)
Using <> because there are blank cells in between dates.

Any help is appreciated.

So there is one date in Sheet1 associated to the name in A5?

If so, try:

=SUMIF('Sheet1!$A$2:$A$5000,A5,'Sheet1!$G$2:$G$5000)+90

which you will need to format as date.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save