Difficult look up formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Out of the samples you posted, what matches?

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

Biff
 
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!
 
You must log in or register to reply here.

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
Compare identifier columns from 2 sheets - remove rows that are dups 2
Excel VBA to move cells to sheet2 based on selection in sheet1 0
EXCEL: find string in vector & return cell reference 1
IF function possible? 4
Need help with ISNA, INDEX, MATCH 2
Figuring Dates quit working! 2
First column of range in VLOOKUP contains formula 2

Back
Top