# 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

Martin Liss

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

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

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.

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
Do you have a sample of what the output worsheet should look like?

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.

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
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

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

How do I get 111 from 2611?
How do I get 666 from 2611?

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
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?

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
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?

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
 BQ BR BS BT BU BV BW 611 111 666 449 227 833 499 M N O P Q R S
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)
 BQ BR 405 555 335 444 839 888 435 555 M N

but i still add more data for each cell

i see columns M to S in DTON
as an table

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?

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

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 611 111 666 449 227 833 499

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

How is 833 a part of 611?????

833 is an follow number of 611

this is what i study
So are you saying that it comes from column N?

 sheet1 Q BR BS BT BU BV BW MATCH with ORD (BF) 611 111 666 449 227 833 499 DTON M N O P Q R S

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

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?

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 OUTPUT BQ BR BS BT BU BV BW 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 611 111 666 449 227 833 499 SOURCE is DTON M N O P Q R S

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
Martin Liss

membership
Create an account to see this answer
Signing up is free. No credit card required.

Great Job

Best Expert !

very impressive and beautiful
Thanks  Best Expert !
It works for me.
Click anywhere besides BX1:CX1 and then click PAIR and see if that works.

Working!!

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
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.