match an tri in 4n dreturn
4NKFile then Add 2DIGITRETURN
1- we have sheet DTON with data from C3 to C59
2- need match this with the ORD when some occurrence happens
3- the list call 2Dreturn is alredy work as an ORD list
4-but any orden can happens in ORD
5- then show an color format in column AX in sheet1 to knows the match is happpens
Last Comment
ASKER
I need to match or rather identify in ORD
the numbers from the 2Dreturn list
If the number of the list is in ORD, I need to know it
the numbers from the 2Dreturn list
If the number of the list is in ORD, I need to know it
Please answer my questions.
ASKER
an example of something similar
if you go to BF16 you will see a number in metallic blue
but if you base column BQ16 you will see a marker that helps me identify it
something like this but this time with 2Dreturn list
if you go to BF16 you will see a number in metallic blue
but if you base column BQ16 you will see a marker that helps me identify it
something like this but this time with 2Dreturn list
ASKER
2- need match this with the ORD when some occurrence happensWhat occurrence?
i means everytime ORD is happenings
need alert me if it has an 2Dreturn
3- the list call 2Dreturn is alredy work as an ORD listI don't know what that means.
the list is worked to be in the ORD order
but any orden can happens in ORDI don't know what that means.
I want match any 2dreturn happens in ORD
then show an color format in column AX in sheet1 to knows the match is happpensWhat color?
as showsup
ASKER
the detail here is an ORD number is 4 digit
and the 2dreturn is an 3 digit number
but need to identify them when they appear in the ord
and the 2dreturn is an 3 digit number
but need to identify them when they appear in the ord
Why not use column BG?
How about using a check mask instead of a color?
The first 2D Return number you show is 015. In order to match that number would the ORD have to contain "015"? Would an ORD of 0115 match?
How about using a check mask instead of a color?
The first 2D Return number you show is 015. In order to match that number would the ORD have to contain "015"? Would an ORD of 0115 match?
ASKER
Why not use column BG?
column AX is the area i will have others too
BG will not be the area
How about using a check mask instead of a color?
can be an word like TRUE
it will not be suitable in this case because I will have other indicators and it's easy a color
The first 2D Return number you show is 015. In order to match that number would the ORD have to contain "015"? Would an ORD of 0115 match?
yes is an match
015 is the number but can be in any position in ORD
column AX is the area i will have others too
BG will not be the area
How about using a check mask instead of a color?
can be an word like TRUE
it will not be suitable in this case because I will have other indicators and it's easy a color
The first 2D Return number you show is 015. In order to match that number would the ORD have to contain "015"? Would an ORD of 0115 match?
yes is an match
015 is the number but can be in any position in ORD
Okay, last question. I know that the color should show up if there's a match, but what action triggers the lookup? A button? A change in the ORD column? Or?
De acuerdo, última pregunta. Sé que el color debería aparecer si hay una coincidencia, pero ¿qué acción desencadena la búsqueda? ¿Un botón? ¿Un cambio en la columna ORD? ¿O?
De acuerdo, última pregunta. Sé que el color debería aparecer si hay una coincidencia, pero ¿qué acción desencadena la búsqueda? ¿Un botón? ¿Un cambio en la columna ORD? ¿O?
ASKER
if you put the word true that activates the color
as in conditional formatting
that's what activates the blue color in the example of the blue color
as in conditional formatting
that's what activates the blue color in the example of the blue color
You aren't understanding what I'm asking. What Excel action causes True to be there?
No entiendes lo que te estoy preguntando. ¿Qué acción de Excel hace que True esté allí?
No entiendes lo que te estoy preguntando. ¿Qué acción de Excel hace que True esté allí?
ASKER
ASKER
You still don't understand. I don't type "True" or "False" into the cells so what action causes the ORDs to be compared with sheet DTON?
Aún no lo entiendes. No escribo "Verdadero" o "Falso" en las celdas, entonces, ¿qué acción hace que los ORD se comparen con la hoja DTON?
Aún no lo entiendes. No escribo "Verdadero" o "Falso" en las celdas, entonces, ¿qué acción hace que los ORD se comparen con la hoja DTON?
ASKER
I understand I will recommend a button as an action
Could that button be used for other actions?
I understand, yes
I mean other similar comparisons
Could that button be used for other actions?
I understand, yes
I mean other similar comparisons
Sure, but after we are done with this please.
ASKER
I agree with you!!
Sorry but one more question. We are matching 3 digits in the DTON sheet with 4 digits in the ORD, so why does the DTON column C header say "2DRETURN"?
Lo siento, pero una pregunta más. Estamos haciendo coincidir 3 dígitos en la hoja DTON con 4 dígitos en el ORD, entonces, ¿por qué el encabezado de la columna C de DTON dice "2DRETURN"?
Lo siento, pero una pregunta más. Estamos haciendo coincidir 3 dígitos en la hoja DTON con 4 dígitos en el ORD, entonces, ¿por qué el encabezado de la columna C de DTON dice "2DRETURN"?
ASKER
They are really 3 digits but they behave in a way that at least they can call 2 in combinations
In the attached workbook there's a new button called DTON near column AX on sheet1. When clicked it will look for matches in the DTON sheet.
If the color in AX is not the color you want then please go here and let me know the RGB value you want to use. Also for testing I put the matching DTON row number in AX. If you don't want that then let me know.
29223764.xlsb
If the color in AX is not the color you want then please go here and let me know the RGB value you want to use. Also for testing I put the matching DTON row number in AX. If you don't want that then let me know.
29223764.xlsb
ASKER
I like is Great !!!
but instead of putting the row number
Please help me by showing me the number on the list
that would help me more !!! Can you please !!
but instead of putting the row number
Please help me by showing me the number on the list
that would help me more !!! Can you please !!
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Nobody can beat the Very Best Expert!
Great Job !
Great Job !
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
I don't know what that means.
I don't know what that means.
What color?