Avatar of ADRIANA P
ADRIANA PFlag for United States of America

asked on 

match an tri in 4n dreturn

4NKFile then Add 2DIGITRETURN

29223100b - Copy (2).xlsb


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 



Microsoft ExcelVBAMicrosoft Office

Avatar of undefined
Last Comment
ADRIANA P
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

2- need match this with the ORD when some occurrence happens
What occurrence?
3- the list  call 2Dreturn  is alredy work as an ORD list
I don't know what that means.
but any orden can happens in ORD
I don't know what that means.
then show an color format in column AX in sheet1 to knows the match is happpens
What color?
Avatar of ADRIANA P
ADRIANA P
Flag of United States of America image

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
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Please answer my questions.
Avatar of ADRIANA P
ADRIANA P
Flag of United States of America image

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
Avatar of ADRIANA P
ADRIANA P
Flag of United States of America image

ASKER

2- need match this with the ORD when some occurrence happens
What 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 list
I don't know what that means.

the list is worked to be in the ORD order

but any orden can happens in ORD
I 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 happpens
What color?

as showsup
User generated image
Avatar of ADRIANA P
ADRIANA P
Flag of United States of America image

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 
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

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?
Avatar of ADRIANA P
ADRIANA P
Flag of United States of America image

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


Avatar of Martin Liss
Martin Liss
Flag of United States of America image

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?
Avatar of ADRIANA P
ADRIANA P
Flag of United States of America image

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
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

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í?
Avatar of ADRIANA P
ADRIANA P
Flag of United States of America image

ASKER

User generated image
Avatar of ADRIANA P
ADRIANA P
Flag of United States of America image

ASKER

User generated image

Avatar of Martin Liss
Martin Liss
Flag of United States of America image

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?
Avatar of ADRIANA P
ADRIANA P
Flag of United States of America image

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
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Sure, but after we are done with this please.
Avatar of ADRIANA P
ADRIANA P
Flag of United States of America image

ASKER

I agree with you!!
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

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"?
Avatar of ADRIANA P
ADRIANA P
Flag of United States of America image

ASKER

They are really 3 digits but they behave in a way that at least they can call 2 in combinations
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

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
Avatar of ADRIANA P
ADRIANA P
Flag of United States of America image

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 !!
ASKER CERTIFIED SOLUTION
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Blurred text
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.
See Pricing Options
Start Free Trial
Avatar of ADRIANA P
ADRIANA P
Flag of United States of America image

ASKER

Nobody can beat the Very  Best  Expert!

Great Job !
Microsoft Excel
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
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo