Thread: [Solved] Boxing vlookup, if and AND to retrieve value
View Single Post
 
Old 09-14-2022, 02:59 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 10 Office 2021
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,780
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
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 ?
__________________
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