Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-14-2017, 06:38 AM
mandarin mandarin is offline Using IF AND and VLOOKUP Windows 10 Using IF AND and VLOOKUP Office 2016
Novice
Using IF AND and VLOOKUP
 
Join Date: Nov 2017
Location: South Africa
Posts: 2
mandarin is on a distinguished road
Default Using IF AND and VLOOKUP

In one workbook I need to lookup where the date in a cell (E2) and the value in a cell (B3) are equal to a date and value in a 2 separate columns (date is column C and value is column A) in a different worksheet (same workbook) and return the value in the corresponding cell in column O
Attached Files
File Type: xlsx Excel Sample.xlsx (17.5 KB, 11 views)
Reply With Quote
  #2  
Old 11-14-2017, 07:27 AM
NBVC's Avatar
NBVC NBVC is offline Using IF AND and VLOOKUP Windows 10 Using IF AND and VLOOKUP Office 2013
The Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default

Try:

=SUMIFS(Driving_Style[[Distance Travelled (km)]:[Distance Travelled (km)]],Driving_Style[[Registration]:[Registration]],$B3,Driving_Style[[Date]:[Date]],E$2)

copied down and across
Reply With Quote
  #3  
Old 11-14-2017, 08:55 AM
mandarin mandarin is offline Using IF AND and VLOOKUP Windows 10 Using IF AND and VLOOKUP Office 2016
Novice
Using IF AND and VLOOKUP
 
Join Date: Nov 2017
Location: South Africa
Posts: 2
mandarin is on a distinguished road
Default

Thank you so much! This seems to have done it
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with Vlookup Ami Excel 1 03-08-2017 02:16 PM
Using IF AND and VLOOKUP vlookup help framedbyhanging Excel 7 12-31-2014 09:57 PM
Using IF AND and VLOOKUP Using IF and VLOOKUP together Becki Excel 2 04-06-2012 05:32 PM
something like VLOOKUP hanvyj Excel 4 03-13-2012 09:03 AM
Using IF AND and VLOOKUP Vlookup ibrahimaa Excel 5 03-04-2012 11:24 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:23 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft