Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have 3 worksheets of data. The master worksheet 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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Match data in 2 columns and return data from 3rd column | Excel Worksheet Functions | |||
Why do my data labels do not match source data? | Charts and Charting in Excel | |||
Find, Match data and paste data between two workbooks | Excel Discussion (Misc queries) | |||
index,match,match on un-sorted data | Excel Worksheet Functions | |||
The match and lookup functions can find literal data but not the same data referenced from a cell | Excel Discussion (Misc queries) |