Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
Thread | Forum | |||
compare worksheets | New Users to Excel | |||
Compare Worksheets | Excel Discussion (Misc queries) | |||
compare worksheets | Excel Discussion (Misc queries) | |||
Compare the 1st 9 digits in two columns looking for duplicates | Excel Worksheet Functions | |||
How do I compare in between two worksheets? | Excel Worksheet Functions |