Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 09-14-2022, 03:32 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 Pecoflyer View Post
I don't see any expected results..
If the value of AGE is between two numbers, which ID should be returned??


PS I hope your cold is getting better ?
hm...

Every "ID" should be returned where "age" is between the 2 numbers. I know how to get the rest of the information automatically. The number of rows in "data" can vary a lot.

So in essence I will create sheets for every "age"-group I need (most are between 2 values, 1 is above 64800). In essence this creates a filter by "age"

I don't have a cold
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:58 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