I see a few issues with the first argument of your VLOOKUP function. @$D$8:$D$694
1. The value you look up should be a single value, not a whole range of values.
2. Why do you have an "@" in front of the range? I don't think that should be there.
You are doing this in Excel, and not Google Sheets or an Open Source Document, right?
That range looks for the number in that row range to match the numbers on Detailed_View range. to return what's in ,8. This works i just need to add to it to use it in a different way.
If the word Monday is also in column E on Detailed row with the D columns matching then return the value in ,8
ok I change it to 365 my profile. This formula works also, but i need it to only return if column E also on Detailed_view says Monday.
=IFERROR(VLOOKUP(D8, Detailed_View!$D$2:$P$395,8,0),"") This works like my other one but trying to add to it if Monday is in column E.
I have picture below. Trying to lookup the same number lets say its 39 and also E has to say Monday. Then is can return what's in ,8. Making sure the number matches and its Monday in E to return value in ,8