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

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

ASKER

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

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.

ASKER

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

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

ASKER

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

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

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

ASKER

Put

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

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

How do I get 666 from 2611?

ASKER

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

611 = 111 = 666 = 449 = 227 =

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?

**833**= 499I 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

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

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?

ASKER

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

It's confusing to talk about the future so please just answer for

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?

__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

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 !

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

ASKER

833 is an follow number of 611

ASKER

this is what i study

So are you saying that it comes from column N?

ASKER

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?

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?

ASKER

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

ASKER CERTIFIED SOLUTION

membership

Create an account to see this answer

Signing up is free. No credit card required.

ASKER

Great Job

Best Expert !

Best Expert !

ASKER

very impressive and beautiful

Thanks Best Expert !

Thanks Best Expert !

ASKER

Working!!

ASKER

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.

ASKER

ok