|
|
#1
11-14-2017, 06:38 AM
|
|||
|
|||
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
|
|
#2
11-14-2017, 07:27 AM
|
||||
|
||||
|
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
|
|
|
|
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 |
Windows 10 
Office 2016
Linear Mode
