Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vbscript for partial match in two columns
I want to implement the following the Match function:
Suppose two columns are B C a,b,c b,c d,e d a,e f I want to have a script which can return the index of C column which match to part of B column, for example for B1, part of B match to part of C, so the function should return 1. For B2, it should return 2. For B3, it should return N/A. In vbscript, there is match function, Match(B1, C:C, 0 ) can return the index of C column for exact match of B1.But In this case, I need a partial match. Can only one help me about this using vbscript? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup on partial match | Excel Worksheet Functions | |||
Find partial match from column A,B and fill partial match in C? | Excel Discussion (Misc queries) | |||
Match Values in Rows with Partial Values in Columns | Excel Worksheet Functions | |||
DSUM Partial Match | Excel Worksheet Functions | |||
partial lookup/match | Excel Worksheet Functions |