Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 05-16-2018, 02:34 AM
ArviLaanemets ArviLaanemets is offline I am trying to cross reference data, and I need the right formula. Windows 8 I am trying to cross reference data, and I need the right formula. Office 2016
Expert
 
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

I could not desipher, what you exactly wanted, so I made 2 possible solutions. On sheet Shedule, columns for Rep1 take loads sent actually out as base, and are matching them with scheduled loads. Colums for Rep2 take scheduled loads as base, and are matching them with actual loads.

In either of reports, something is left out. To get a report, where all scheduled loads and all actual loads are displayed, and positioned to match, can't be made in same table, and is much more complex to create.

Btw, in my solution the actual position of loads in table is moot - the load numbers are calculated based on scheduled/actual time.
Attached Files
File Type: xlsx example2.xlsx (23.2 KB, 17 views)
Reply With Quote
 

Tags
cross referencing, formula help, index match



Similar Threads
Thread Thread Starter Forum Replies Last Post
Cross reference data from 2 different worksheets connell.richard@gmail.com Excel 0 12-06-2016 04:26 AM
Cross-reference / lookup data from one tab and display on another - How to lonniepoet Excel 0 02-24-2016 01:31 PM
I am trying to cross reference data, and I need the right formula. Formulas/Scripts That Cross Reference & Import Data ekeithjohnson Excel Programming 3 08-23-2014 11:26 PM
I am trying to cross reference data, and I need the right formula. Reference number and cross reference for equation numbers to match the thesis format wmac Word 1 05-14-2013 08:54 PM
I am trying to cross reference data, and I need the right formula. Cross-reference together with Mathtype formula is not working correct Santa_Clause Word 2 02-02-2010 04:37 AM

Other Forums: Access Forums

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


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