Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 11-14-2017, 06:38 AM
mandarin mandarin is offline Windows 10 Office 2016
Novice
 
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, 2 views)
Reply With Quote
  #2  
Old 11-14-2017, 07:27 AM
NBVC's Avatar
NBVC NBVC is offline Windows 10 Office 2013
A Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 121
NBVC is on a distinguished road
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 Windows 10 Office 2016
Novice
 
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
vlookup help framedbyhanging Excel 7 12-31-2014 09:57 PM
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
Vlookup ibrahimaa Excel 5 03-04-2012 11:24 AM


All times are GMT -7. The time now is 06:40 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft