Difficult look up formula

A

Alex

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

Biff

Hi!

Out of the samples you posted, what matches?

I don't see anything that is even close to a match!

Biff
 
A

Alex

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

using wildcards in vlookup 5
Need Help with a VBA subroutine 0
Compare identifier columns from 2 sheets - remove rows that are dups 2
use month in cell date to sum all relevant cells 2
Table cross-check 0
help with a vlookup 2
Need help with ISNA, INDEX, MATCH 2
IF ARRAY with multiple conditions. 1

Top