Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Difficult look up formula
I have the following example of cell values in the MSO column on Sheet1
MSO 088234592 088234592 088234592 088234592 NPQW1 NQCT8 NQCT8 I have the following example of cell values in the TRK column on Sheet2 TRK JVB65/NVZH9/Z1D00465 JVB65/NVZJ0/Z1D00464 JVB65/NVZK5/Z1K04341 JVB65/NWBZ5/Z1B02051 JVBBP-MPQB8 2653008 JVBBP-NNGX7 2397611 JVBBP-NPTZ9 2516847 JVBBP-NPVB0 2516847 I need to add an additional column in Sheet 1 and for each MSO in sheet1, I need to see if there is a matching MSO anywhere in the TRK column on Sheet 2. If there is, I need to enter the ORDER# of the matching TRK. I'm stumped because of the of the different formatting the the TRK column. Any help is appreciated. Thanks so much. |
#2
|
|||
|
|||
Hi!
Out of the samples you posted, what matches? I don't see anything that is even close to a match! Biff "Alex" wrote in message ... I have the following example of cell values in the MSO column on Sheet1 MSO 088234592 088234592 088234592 088234592 NPQW1 NQCT8 NQCT8 I have the following example of cell values in the TRK column on Sheet2 TRK JVB65/NVZH9/Z1D00465 JVB65/NVZJ0/Z1D00464 JVB65/NVZK5/Z1K04341 JVB65/NWBZ5/Z1B02051 JVBBP-MPQB8 2653008 JVBBP-NNGX7 2397611 JVBBP-NPTZ9 2516847 JVBBP-NPVB0 2516847 I need to add an additional column in Sheet 1 and for each MSO in sheet1, I need to see if there is a matching MSO anywhere in the TRK column on Sheet 2. If there is, I need to enter the ORDER# of the matching TRK. I'm stumped because of the of the different formatting the the TRK column. Any help is appreciated. Thanks so much. |
#3
|
|||
|
|||
You're right - I was just copying and pasting and didn't match them. I've
added some that match: I have the following example of cell values in the MSO column on Sheet1 MSO 088234592 088234592 088234592 088234592 NPQW1 NQCT9 NQCT8 I have the following example of cell values in the TRK column on Sheet2 TRK JVB65/NVZH9/Z1D00465 JVB65/NPQW1/Z1D00464 JVB65/NVZK5/Z1K04341 JVB65/88234592/Z1B02051 JVBBP-MPQB8 2653008 JVBBP-NNGX7 2397611 JVBBP-NQCT8 2516847 JVBBP-NPVB0 2516847 I need to add an additional column in Sheet 1 and for each MSO in sheet1, I need to see if there is a matching MSO anywhere in the TRK column on Sheet 2. If there is, I need to enter the ORDER# of the matching TRK. I'm stumped because of the of the different formatting the the TRK column. Thanks again! "Biff" wrote: Hi! Out of the samples you posted, what matches? I don't see anything that is even close to a match! Biff "Alex" wrote in message ... I have the following example of cell values in the MSO column on Sheet1 MSO 088234592 088234592 088234592 088234592 NPQW1 NQCT8 NQCT8 I have the following example of cell values in the TRK column on Sheet2 TRK JVB65/NVZH9/Z1D00465 JVB65/NVZJ0/Z1D00464 JVB65/NVZK5/Z1K04341 JVB65/NWBZ5/Z1B02051 JVBBP-MPQB8 2653008 JVBBP-NNGX7 2397611 JVBBP-NPTZ9 2516847 JVBBP-NPVB0 2516847 I need to add an additional column in Sheet 1 and for each MSO in sheet1, I need to see if there is a matching MSO anywhere in the TRK column on Sheet 2. If there is, I need to enter the ORDER# of the matching TRK. I'm stumped because of the of the different formatting the the TRK column. Any help is appreciated. Thanks so much. |
#4
|
|||
|
|||
Was this already not answered earlier on Jun 14
http://groups-beta.google.com/group/...7 5c4d78c6f8e What different now? "Alex" wrote in message ... You're right - I was just copying and pasting and didn't match them. I've added some that match: I have the following example of cell values in the MSO column on Sheet1 MSO 088234592 088234592 088234592 088234592 NPQW1 NQCT9 NQCT8 I have the following example of cell values in the TRK column on Sheet2 TRK JVB65/NVZH9/Z1D00465 JVB65/NPQW1/Z1D00464 JVB65/NVZK5/Z1K04341 JVB65/88234592/Z1B02051 JVBBP-MPQB8 2653008 JVBBP-NNGX7 2397611 JVBBP-NQCT8 2516847 JVBBP-NPVB0 2516847 I need to add an additional column in Sheet 1 and for each MSO in sheet1, I need to see if there is a matching MSO anywhere in the TRK column on Sheet 2. If there is, I need to enter the ORDER# of the matching TRK. I'm stumped because of the of the different formatting the the TRK column. Thanks again! "Biff" wrote: Hi! Out of the samples you posted, what matches? I don't see anything that is even close to a match! Biff "Alex" wrote in message ... I have the following example of cell values in the MSO column on Sheet1 MSO 088234592 088234592 088234592 088234592 NPQW1 NQCT8 NQCT8 I have the following example of cell values in the TRK column on Sheet2 TRK JVB65/NVZH9/Z1D00465 JVB65/NVZJ0/Z1D00464 JVB65/NVZK5/Z1K04341 JVB65/NWBZ5/Z1B02051 JVBBP-MPQB8 2653008 JVBBP-NNGX7 2397611 JVBBP-NPTZ9 2516847 JVBBP-NPVB0 2516847 I need to add an additional column in Sheet 1 and for each MSO in sheet1, I need to see if there is a matching MSO anywhere in the TRK column on Sheet 2. If there is, I need to enter the ORDER# of the matching TRK. I'm stumped because of the of the different formatting the the TRK column. Any help is appreciated. Thanks so much. |
#5
|
|||
|
|||
No because it's reversed, but I'll figure it out
"N Harkawat" wrote: Was this already not answered earlier on Jun 14 http://groups-beta.google.com/group/...7 5c4d78c6f8e What different now? "Alex" wrote in message ... You're right - I was just copying and pasting and didn't match them. I've added some that match: I have the following example of cell values in the MSO column on Sheet1 MSO 088234592 088234592 088234592 088234592 NPQW1 NQCT9 NQCT8 I have the following example of cell values in the TRK column on Sheet2 TRK JVB65/NVZH9/Z1D00465 JVB65/NPQW1/Z1D00464 JVB65/NVZK5/Z1K04341 JVB65/88234592/Z1B02051 JVBBP-MPQB8 2653008 JVBBP-NNGX7 2397611 JVBBP-NQCT8 2516847 JVBBP-NPVB0 2516847 I need to add an additional column in Sheet 1 and for each MSO in sheet1, I need to see if there is a matching MSO anywhere in the TRK column on Sheet 2. If there is, I need to enter the ORDER# of the matching TRK. I'm stumped because of the of the different formatting the the TRK column. Thanks again! "Biff" wrote: Hi! Out of the samples you posted, what matches? I don't see anything that is even close to a match! Biff "Alex" wrote in message ... I have the following example of cell values in the MSO column on Sheet1 MSO 088234592 088234592 088234592 088234592 NPQW1 NQCT8 NQCT8 I have the following example of cell values in the TRK column on Sheet2 TRK JVB65/NVZH9/Z1D00465 JVB65/NVZJ0/Z1D00464 JVB65/NVZK5/Z1K04341 JVB65/NWBZ5/Z1B02051 JVBBP-MPQB8 2653008 JVBBP-NNGX7 2397611 JVBBP-NPTZ9 2516847 JVBBP-NPVB0 2516847 I need to add an additional column in Sheet 1 and for each MSO in sheet1, I need to see if there is a matching MSO anywhere in the TRK column on Sheet 2. If there is, I need to enter the ORDER# of the matching TRK. I'm stumped because of the of the different formatting the the TRK column. Any help is appreciated. Thanks so much. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
Another difficult failed formula | Excel Worksheet Functions | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |