ADRIANA P asked on # Match tri ord with in various columns

4n to adjuss PAIRSETS button

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

Martin Liss

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

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

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.

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

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

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?

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.

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

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

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

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

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?

How do I get 666 from 2611?

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

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?

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?

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

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?

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

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

BQ | BR | BS | BT | BU | BV | BW |

611 | 111 | 666 | 449 | 227 | 833 | 499 |

M | N | O | P | Q | R | S |

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

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?

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?

ADRIANA P

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

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

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

ADRIANA P

833 is an follow number of 611

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?

ADRIANA P

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

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?

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.

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

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

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

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

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.

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

Great Job

Best Expert !

Best Expert !

ADRIANA P

very impressive and beautiful

Thanks Best Expert !

Thanks Best Expert !

Your help has saved me hundreds of hours of internet surfing.

fblack61

Martin Liss

ADRIANA P

Working!!

ADRIANA P

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.

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.

ADRIANA P

ok