Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #10  
Old 09-14-2022, 02:55 AM
Deichgraf Deichgraf is offline Boxing vlookup, if and AND to retrieve value Windows 11 Boxing vlookup, if and AND to retrieve value Office 2021
Novice
Boxing vlookup, if and AND to retrieve value
 
Join Date: Sep 2022
Posts: 10
Deichgraf is on a distinguished road
Default

Quote:
Originally Posted by ArviLaanemets View Post
Attached is an example of possible solution using worksheet functions only.
hm...

This looks like the best basis to work with. But I can't follow the way the formulas work.

Would I need to adjust the helper columns in data manually?
The data that will be copied there never changes when it comes to columns, but the rows can vary wildly to up to 12.000.

I would use the "Report" sheet as the basis to create the sheet where the "feedback" and "progress" can be added as that is the most important part about the entire file.

In that case I only need to generate multiple report sheets for each "age group" (ages 10080 - 20160, 20161 - 30240, 30241 - 43200, 43201 - 64800, above 64800).
This sheet would only need to contain the "ID", as it only serves as a helping sheet to filter data by "age".

The only formula I have a tenuous grasp on is the one in RepRow, but nStartAge and nEndAge throws me off. I know that it refers to the values in "Report", but I don't know how.
I need to understand it, so I can create the sheets where users can enter their feedback and progress.

Thank you fjns and ArviLaanemets for the great work!
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Retrieve Old Email Folder pmokover Outlook 0 07-15-2021 09:01 AM
Tell me which place the vlookup was successful (within a nested vlookup) Izzii0x Excel 2 07-18-2019 10:29 PM
How can I return Vlookup only if Specific Criteria is met in 1 column of the Vlookup Array EcommDOC Excel 7 01-22-2018 11:00 AM
Boxing vlookup, if and AND to retrieve value Retrieve the last activated document name. eduzs Word VBA 1 08-22-2017 03:11 PM
Retrieve PPS files uncledewey PowerPoint 2 08-10-2012 09:08 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:07 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