how to match data
 

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!

how to match data
 

I think you are getting your rows and columns mixed up - rows are
numbered and columns are referred to by letters (usually). It makes it
difficult to follow your description if you use these terms
incorrectly.

Anyway, look in Excel Help for the functions LEFT, MATCH, INDEX,
VLOOKUP and ISNA, all of which will be helpful to you in this task.

Hope this helps.

Pete

On Jan 31, 3:34*pm, NeedExcelHelp07
wrote:
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!

how to match data
 

Ok. I would like to have D2 in worksheet ipc search all the rows in column D
in worksheets vb or pb for a match of the first 8 chracters. My problem is
writing a formula matching the first 8 chracters in different worksheets.



"Pete_UK" wrote:

I think you are getting your rows and columns mixed up - rows are
numbered and columns are referred to by letters (usually). It makes it
difficult to follow your description if you use these terms
incorrectly.

Anyway, look in Excel Help for the functions LEFT, MATCH, INDEX,
VLOOKUP and ISNA, all of which will be helpful to you in this task.

Hope this helps.

Pete

On Jan 31, 3:34 pm, NeedExcelHelp07
wrote:
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!

how to match data
 

Okay, here's a generic formula:

=IF(ISNA(vlookup_1),IF(ISNA(vlookup_2),"not
present",vlookup_2),vlookup_1)

where vlookup_1 and vlookup_2 are formulae looking up data in table_1
and table_2 respectively. In your case, then, sheet vp corresponds to
table_1 and sheet pb to table_2. You might like to change the "not
present" to FALSE. This will look in table_1 and then in table_2 if it
is not found in table_1.

The vlookup terms will be something like this:

VLOOKUP(D2&"*",vp!D:E,2,0)

This will look for a match in column D of sheet vp and return the
corresponding value from column E.

Just substitute as appropriate in the generic formula.

Hope this helps.

Pete

On Jan 31, 4:22*pm, NeedExcelHelp07
wrote:
Ok. I would like to have D2 in worksheet ipc search all the rows in column D
in worksheets vb or pb for a match of the first 8 chracters. My problem is
writing a formula matching the first 8 chracters in different worksheets.



"Pete_UK" wrote:
I think you are getting your rows and columns mixed up - rows are
numbered and columns are referred to by letters (usually). It makes it
difficult to follow your description if you use these terms
incorrectly.

Anyway, look in Excel Help for the functions LEFT, MATCH, INDEX,
VLOOKUP and ISNA, all of which will be helpful to you in this task.

Hope this helps.

Pete

On Jan 31, 3:34 pm, NeedExcelHelp07
wrote:
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!- Hide quoted text -

- Show quoted text -