Using IF AND and VLOOKUP

		Microsoft Office Forums > Microsoft Excel > Excel
Using IF AND and VLOOKUP

FAQ

Thread Tools

Display Modes

11-14-2017, 07:27 AM

NBVC

Windows 10 Using IF AND and VLOOKUP

Office 2013

The Formula Guy

Join Date: Mar 2012

Location: Mississauga, CANADA

Posts: 215

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

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 06:50 AM.