Avatar of ADRIANA P
ADRIANA PFlag for United States of America asked on

Match tri ord with in various columns

4n to adjuss PAIRSETS button 

29224260b (1).xlsb

as we did here but now for  this https://www.experts-exchange.com/questions/29223815/match-an-tri-in-various-series.html


Column M is the match to BF

shown the output  columns BQ to BW


1- From columns M to S  DTON sheet

2- some have the complete M to S some just 2 columns

3- more data will be update so i can update



Microsoft ExcelVBAMicrosoft Office

Avatar of undefined
Last Comment
ADRIANA P

8/22/2022 - Mon
Martin Liss

I don't understand what you are asking me to do.
ASKER
ADRIANA P

1- in sheet DTON we have  columns M to S

2- Although they are in different columns M TO S they make one but it is divided into M to S

3-The columns M in DTON  sheet is the MAIN column  for the complete  row (M to S)
N O P P Q R S always follow column M
that is, they are the continuation of column M

4- need MATCH column M from DTON to ORD (BF in sheet1)

when a number is presented in COlumn BF (ORD) that matches the Number of column M in DTON
then it is presented in the columns BQ BR BS BT BU BV BW
in sheet1


5- we had already done something similar in this question

https://www.experts-exchange.com/questions/29223815/match-an-tri-in-various-series.html

https://www.experts-exchange.com/questions/29223764/match-an-tri-in-4n-dreturn.html



The only thing that changes in this situation is that there are several columns related to the main column, which is the column M in DTON






Martin Liss

I still don't understand so tell me me what button I should click and/or what cell I should select and then tell me what should happen. In other words what the output should be.

Sigo sin entender, así que dime qué botón debo hacer clic y / o qué celda debo seleccionar y luego dime qué debería suceder. En otras palabras, cuál debería ser la salida.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
ASKER
ADRIANA P

create a button call it TRIG and put it in BS1
  when you press this button it should match
in ORD by Row the numbers that appear in column M of the DTON sheet

the detail here is an ORD number is 4 digit

and the TRIG column M  is an 3 digit number


but need to identify them when they appear in the ord  in any position
Martin Liss

Do you have a sample of what the output worsheet should look like?
ASKER
ADRIANA P

Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Martin Liss

I understand that in your example that I need to lookup 2611 on the DTON worksheet, but for each of the 7 columns in BQ:BW I need you to tell me what matches on the DTON sheet and why BQ is 611 and BR is 111, etc.
ASKER
ADRIANA P

sure

  611  111  666   449  227  833  499  

here I have this situation

611 = 111

but too = 666 = 449 =  227 =  833  499


While BF 4805 = 405 = 555  only  


I could have put  611  111  666   449  227  833  499  in a single cell

but what I did was put each data in a different cell

but when you call 611 you have to call all the data that is 611
Martin Liss

Please tell me this way. The "___" represent numbers.
Put ___ in column BQ because ___ in 2611 matches ___ in DTON column M (is it always column M?)
Put ___ in column BR because ___ in 2611 matches ___ in DTON column _
etcetera
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
ASKER
ADRIANA P

Put 611 in column BQ because __611_ in 2611 matches _611__ in DTON column M (is it always column M?)

Put _111__ in column BR because _111_ in 2611 matches _ 611__ in DTON column  M

Put _666__ in column BS because __666_ in 2611 matches _611__ in DTON column _M

Put _449__ in column BR because __449_ in 2611 matches _611__ in DTON column _M
etc...
 

 is it always column M?

Yes columns M is the Key for all numbers in DTON  columns M , N, O, P, Q, R, S

 
when a number from column M of Sheet DTON
is in BF (ORD) in any position brings the entire row that is in M, N, O, P, Q, R, S and is presented in columns BQ, BR, BS, BT, BU,
BV, BW respectively

BF (ORD) is a 4 digit number but column M sheet DTON is only 3 digits but if it appears in any position of BF (ORD) it is necessary to present it




Martin Liss

How do I get 111 from 2611?
How do I get 666 from 2611?
ASKER
ADRIANA P

2611 has 611

611 = 111 = 666 = 449 = 227 = 833 = 499


that is why it is the match between column BF sheet 1 and Column M on sheet DTON

When a number in column M DTON is in BF ORD, it must be shown in BQ to BW sheet 1 
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Martin Liss

611 = 111 = 666 = 449 = 227 = 833 = 499
I see that all the other values come from DTON row 41 but where does 833 come from?
Veo que todos los demás valores provienen de la fila 41 de DTON, pero ¿de dónde proviene el 833?
ASKER
ADRIANA P

what happens is that when 611 appears in any position of ORD these are the numbers that could follow it

611 = 111 = 666 = 449 = 227 = 833 = 499

you have to see other tracks but it is an idea of where it is going
Martin Liss

So should column BV be blank for now?

Do you want the columns colored like AU:AX? If so should BQ be colored?

I assume that the value in column BQ is the 3N number from BF. Is that true?
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
ASKER
ADRIANA P

So should column BV be blank for now? 

yes but data will be on in some cases as 611 and some others


 sheet1 is  output
BQBRBSBTBUBVBW
611111666449227833499
MNOPQRS
 source DTON IS row 41

for 611 all will be full  

but for other case

BV can be empty  

i still need add more data  



  sheet1  this only have data for 2 places (columns)
BQBR
405555


335444


839888






435555
MN

but i still add more data for each cell


i see columns M to S in DTON 
as an table


Martin Liss

It's confusing to talk about the future so please just answer for now and just for BF = 2611.
I assume that
BQ = 611 because it is the matching TRI.
BR should be 111 from DTON column R
BS should be 666 from DTON column S
BT should be 449 from DTON column P
BU should be 227 from DTON column Q
BV should be blank and for now column BV should always be blank
BW should be 499 from DTON column O

Do you want the columns colored like AU:AX? If so should BQ be colored?
ASKER
ADRIANA P

BV should be blank and for now column BV should always be blank
Please !!

833 is part of 611 can not be blank

 611 is not alone  it have data in the same row
all the data in the same row have to be showsup
M





611111666449227833499


any number in M, N, O, P, Q, R, S  follow M .

M is the Key Column from M, N, O, P, Q, R, S  
so any data in the same row with any number  in the same row follow the M number for that row



Do you want the columns colored like AU:AX? If so should BQ be colored?

in this case no color

but dont delete any format color if i put one when ipress the button

Please !


Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Martin Liss

How is 833 a part of 611?????
ASKER
ADRIANA P

833 is an follow number of 611


ASKER
ADRIANA P

this is what i study
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Martin Liss

So are you saying that it comes from column N?
ASKER
ADRIANA P

sheet1QBRBSBTBUBVBW
MATCH with ORD (BF)611111666449227833499
DTONMNOPQRS


611 belongs from Column M

i need match the Column M from DTON  with the numbers in BF (ORD)  sheet1

when an match happens  it pulls all the rows from DTON Following column M

column M is the one who make the match with columns BF (ORD) and is the one that the row follows completely(rows from M  N O P Q R S columns )

in this case 611 is the leading because it have others columns in the same row they follow it 






Martin Liss

I'm sorry but you are not making sense to me. You keep on saying that everything comes from column M but the only 833 in column M is in row 60. Is that where it comes from?

Lo siento, pero para mí no tiene sentido. Sigues diciendo que todo viene de la columna M pero el único 833 de la columna M está en la fila 60. ¿De ahí viene?
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
ADRIANA P

any numbers showup works by rows
and the columns M is in charge of the Rows

833 only follows 611 because it is in the same row but the number that makes the match is 611 that is in column M

column M in DTON is the column in charge of all the others  

in sheet1 OUTPUTBQBRBSBTBUBVBW
MATCH DTON sheet begining  in Column M  with ORD (BF)
and showsup all the rows (from M,N, O,P,Q, R,S)  in sheet1 BQ to BW
611111666449227833499
SOURCE is DTONMNOPQRS


column M in DTON is the column in charge of all the others

N, O, P, Q, R, S follow columns M by row


in ORD BF we have 2611 so we look to DTON column M and FInd 611
611 is the number to match because it is in column M
and 2611 so the entire row that is where 611 is follows

so 611 in your row has the numbers 611 111 666 449 227 833 499


so when a match of the number in columns M in this case is 611 with 2611


2611 has the matching with column M on DTON sheet

but I need to show the whole row that follows 611


rows q follow column M are contained in N, O, P, Q, R, S



the table of M N O P Q R S in DTON has numbers per row
ASKER CERTIFIED SOLUTION
Martin Liss

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
ADRIANA P

Great Job

Best Expert !
ASKER
ADRIANA P

very impressive and beautiful
Thanks  Best Expert !
Your help has saved me hundreds of hours of internet surfing.
fblack61
Martin Liss

It works for me.
2021-09-17_06-08-48.pngClick anywhere besides BX1:CX1 and then click PAIR and see if that works.
ASKER
ADRIANA P

Working!!
ASKER
ADRIANA P

in general everything working fine but I have this situation

with the number 2477

277 appears in DT ON but does not match me
can be set to appear even when it appears in that position

as shown
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Martin Liss

Please don't report problems that occur in old workbooks if there is a newer one with the same data. Instead test the newest workbook and if the problem occurs there then report the problem in the question that created the latest workbook.

No informe problemas que ocurran en libros de trabajo antiguos si hay uno más nuevo con los mismos datos. En su lugar, pruebe el libro de trabajo más reciente y, si el problema ocurre allí, informe el problema en la pregunta que creó el libro de trabajo más reciente.
ASKER
ADRIANA P

ok