Need to add to existing formula Vlookup

zone709

Well-known Member
Joined
Mar 1, 2016
Messages
1,976
Office Version
  1. 365
Platform
  1. Windows
Need to add on this formula. if Column E on detailed_view also matches has the name Monday. If Monday is there then return ,8

=IFERROR(VLOOKUP(@$D$8:$D$694, Detailed_View!$D$2:$P$395,8,0),"")
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
57,017
Office Version
  1. 365
Platform
  1. Windows
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?
 

zone709

Well-known Member
Joined
Mar 1, 2016
Messages
1,976
Office Version
  1. 365
Platform
  1. Windows
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
 

zone709

Well-known Member
Joined
Mar 1, 2016
Messages
1,976
Office Version
  1. 365
Platform
  1. Windows
If i don't use @ it returns Spill. Not using a single number because it needs to look through the whole column D. I am using Excel 2016.
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
57,017
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

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.

If you try this formula, does it work for you?
Excel Formula:
=IFERROR(VLOOKUP(D8, Detailed_View!$D$2:$P$395,8,0),"")

If not please post a sample of your data, and your expected result, based off of that sample.
 

zone709

Well-known Member
Joined
Mar 1, 2016
Messages
1,976
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

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
 

Attachments

  • Capture 1.JPG
    Capture 1.JPG
    26.6 KB · Views: 4

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
56,860
Office Version
  1. 365
Platform
  1. Windows
Will you only ever have one row that meets both criteria?
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
57,017
Office Version
  1. 365
Platform
  1. Windows
So, maybe something like this:
Excel Formula:
=IF(IFERROR(VLOOKUP(D8, Detailed_View!$D$2:$P$395,2,0),"")="Monday",IFERROR(VLOOKUP(D8, Detailed_View!$D$2:$P$395,8,0),""),"")
This is, of course, assuming that the value in column E is actually text, and not a date formatted to show Monday.
 
Solution

zone709

Well-known Member
Joined
Mar 1, 2016
Messages
1,976
Office Version
  1. 365
Platform
  1. Windows
Yes Both D & D need to match then look for Monday in column E to return the right number in ,8
 

Watch MrExcel Video

Forum statistics

Threads
1,130,142
Messages
5,640,376
Members
417,139
Latest member
bdmprasenjit

We've detected that you are using an adblocker.

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.
Go back
Top