Look up by DATE 3N R

Please attach a workbook that does a similar lookup.

3N TOOL_years.xlsm

I'm sorry Adriana, but that's not what I'm looking for. I need a workbook that shows a form that allows you to select weeks. We've done iy before and I'm hoping I don't have to redo it.

I have no idea which one would help here
I upload this because I think it can help
but can you tell me how i will know which one can help you

My intention is to help but I don't know which one to look at

That's okay, I'll figure it out.

i hope this can help  
but don't know

n3__ DATE_with_SELECTOR_.xlsm

It does help. Thank you.

Which sheet is the source?

"R_DTA"  sheet is

On the DATEDATA sheet you just seem to be showing six weeks of the ORD values for the selected weeks. What purpose does that serve?

En la hoja DATEDATA, parece que muestra seis semanas de los valores de ORD para las semanas seleccionadas. ¿Para qué propósito sirve eso?

i look the key  number

example 1key  

or any i need to compare

then i want all the weeks with the same range number

to see the repeats pair or 3n

But in your picture you show all the ORD values for the six weeks below the selected weeks and that will never change.

sorry i don't  understand

once i know the key i need to look for

i pick up the weeks to compare

im using one week before the same key

because i need see always one week before the key im working

once i know the key i need to look for

i pick up the weeks to compare

What key would give the results shown on DATEDATA?

What key would give the results shown in DATEDATA?

That will vary because I need to see what happens today and then look back.

but it should probably be the same range number or the first 3 or first 4 keys

because the range number does not always repeat exactly

then looking at the first key, then the first and second, then
first second and third together

to identify the most exact number and the longest possible
that is closer to or more similar to the range number I am looking for (today's)

I don't understand.

the range number is broke in keys

if i can't not found the range in full then i look the keys

????

well i don't know what you doubt

if any explain ??

the range number is broke in keys

if i can't not found the range in full then i look the keys

What does that mean? In Spanish please.

I converted the range number to number of keys

is the same numerdivided into sections

I have no idea at all what you want me to do.

No tengo ni idea de lo que quieres que haga.

i need an button  to open an form

then I can select multiples dates as needed in DATEDATA

then Show the ORD 6 weeks belows the selected date

 as the Pic Shows

i will select multiples dates so it can remenbers the selection

because will not near each one

As needed

Great Job !

The Best ! Expert