Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 10-26-2018, 08:59 AM
Marcia's Avatar
Marcia Marcia is offline Index Match Formula to return value from a list with criteria Windows 7 32bit Index Match Formula to return value from a list with criteria Office 2007
Expert
Index Match Formula to return value from a list with criteria
 
Join Date: May 2018
Location: Philippines
Posts: 553
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

Quote:
Originally Posted by ArviLaanemets View Post
I modified your workbook a bit - look for attached file.

To create a workbook for specific conditions (like specific month) is not very productive. Try design the workbook in a way, which allows to work with single workbook with smallest possible number of sheets for data entry, and with single report sheet for same kind of reports. When you do this, you design a workbook once, and may use it for long time without any changes to design. As example I designed a Report sheet based on your Data sheet (I made some changes there btw.)

Thank you for the reply. Yeah, I've applied your method of assigning Row Nos and using these as unique identifiers in other databases that our office handles in our little hometown. Although I have yet to work out how I will use these Row Nos into the required/official forms.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
need Index, Match, Max to return SUMPRODUCT? IRHSAM Excel 0 11-17-2017 09:48 AM
Excel Index and Match function with multiple criteria not searching the next record mushtaqkadar Excel 3 06-17-2017 12:20 AM
Index Match Formula to return value from a list with criteria Create a unique list of values that match a criteria, sorted in order of another criteria BradRichardson Excel 2 01-03-2017 12:25 AM
Index Match Formula to return value from a list with criteria How to make MATCH/INDEX formula return multiple successive responses. danigirl121 Excel 7 06-08-2016 01:57 PM
Index Match Formula to return value from a list with criteria Vlookup or Index/Match - Multiple Criteria ruci1225 Excel 1 01-15-2012 07:31 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:17 PM.


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