is it possible to use a Look up function which contains year refs (01_02, 02_03 etc) to return all the values from the look up table that should contain more than one year ref.
As a general note though, lookups only return ONE piece of data - that which either exactly matches or is the closest match to the value to be looked up - depending on the type of lookup you do
Rgds, Geoff
"Three things are certain: Death, taxes and lost data. Guess which has occurred"
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.