Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #14  
Old 09-15-2022, 03:23 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
Thumbs up

Quote:
Originally Posted by ArviLaanemets View Post
I updated my example, to give you easiest and error-free way to manually add missing ID's to user comments table.

Edit: Btw, age 10079 falls out of age ranges you did declare in post #8!
hm...

This is absolutely perfect (and idiot proof), thank you for all the work you did.

Ages below 10080 aren't relevant for our purposes, that's why I don't mention them, even though they are part of the data sets that get copied into the file.

I just duplicated the tables to set to a single age group, so I have one report and one comment sheet for each age group. That way comments, progress and ID always match up.

Thank you again!

Kind regards,
Jack
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 02:50 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