Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match data up to 8 characters
I have 3 worksheets of data. The master worksheets is called ipc. The other
two worksheets are called, vb and pb. Each row cell is 14 characters long. IPC is the master worksheet and I want to match the data in row D up to the first 8 chracters in worksheets vb and/or pb. In column f in worksheet ipc, if there is a match between the first 8 characters in row d in vb or pb, I want row d from the match row to be displayed on row f. If there's no match, it can say FALSE. I'm looking for any formula or function to make this work. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF criterion to match the first 5 characters. | Excel Worksheet Functions | |||
PARTIAL TEXT MATCH SEARCHING FOR THE FIRST 6 CHARACTERS? | Excel Worksheet Functions | |||
Blank Characters in data | Excel Discussion (Misc queries) | |||
In Excel find characters when multiple characters exist w/i a cel | Excel Worksheet Functions | |||
index,match,match on un-sorted data | Excel Worksheet Functions |