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
I am a bit confused by what you are saying.
Are you really, really comfortable that you fully understand how VLOOKUP works?
If not, here is an explanation: MS Excel: How to use the VLOOKUP Function (WS)
Note that the first argument is typically a single value/cell reference, not a whole range.
If you have other values to look up, that cell reference will change as you copy the formula down the page.
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
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.