| 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. |
| 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) | |||
Threaded Mode
