Boxing vlookup, if and AND to retrieve value

Deichgraf · #12 09-14-2022, 05:26 AM

Quote:

Originally Posted by ArviLaanemets

I used Defined Tables feature.
I also used named ranges (nStartAge, nEndAge) - them you also can see and edit in

About Progress and Feedback - add columns for them into data Table, and enter them there! When you want to enter them on separate sheet, then the ID for them MUST be entered manually - otherwise you can't guarantee that this info remains linked with right ID.

And you don't need different reports for different age groups.

hm...

Ah, thank you for the explanation, I can work with that.

The data table is generated automatically by a software and includes many more ages, which aren't relevant to the guys working with the file (hence my question about the 2 helping columns).
That's why we need the filter in the first place.

I thought I'd be able to fetch the "ID"s from "data" with your method, generate a sheet with the additional info fetched directly from data via INDEX or VLOOKUP (since "ID" is unique) where the people can enter their progress and feedback.

Thank you, so so much!

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
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