Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-14-2022, 02:59 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Boxing vlookup, if and AND to retrieve value Windows 10 Boxing vlookup, if and AND to retrieve value Office 2021
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,943
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default



Quote:
Originally Posted by Deichgraf View Post
hm...

Of course, I added the explanation and expected results.

Edit 2: The expected result is that if the value of AGE is between those 2 numbers, the ID in that row will be copied to the "work" sheet.

Thank you!
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 ?
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #2  
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
Reply



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