Hi,

I have rows of data with Column A being the key identifier in worksheets
SPR1 and SPR2 inside a work book. Reading one of the threads below, I am
using the following formula in SPR3 (3rd worksheet in the same workbook) to
identify a match between SPR2 and SPR1 from Column A in both columns:

=IF(NOT(ISNUMBER(MATCH(spr2!A1,spr1!A:A,0))),"",IN DEX(spr1!A:A,MATCH(spr2!A1,spr1!A:A,0)))

Is there any way to bring the entire Row of data in SPR1 and SPR2 (assuming
they are the same) instead of just column A into SPR3?

Drag/copy the formula across to end of row.


Gord Dibben MS Excel MVP

On Tue, 6 May 2008 07:25:00 -0700, vrk1 wrote:

Hi,

I have rows of data with Column A being the key identifier in worksheets
SPR1 and SPR2 inside a work book. Reading one of the threads below, I am
using the following formula in SPR3 (3rd worksheet in the same workbook) to
identify a match between SPR2 and SPR1 from Column A in both columns:

=IF(NOT(ISNUMBER(MATCH(spr2!A1,spr1!A:A,0))),"",I NDEX(spr1!A:A,MATCH(spr2!A1,spr1!A:A,0)))

Is there any way to bring the entire Row of data in SPR1 and SPR2 (assuming
they are the same) instead of just column A into SPR3?

That did not work.

Please note that Column A is the matching column. I want to bring the rest
of the columns in SPR3 that ties with Column A.

Any other suggestions?

"Gord Dibben" wrote:

Drag/copy the formula across to end of row.


Gord Dibben MS Excel MVP

On Tue, 6 May 2008 07:25:00 -0700, vrk1 wrote:

Hi,

I have rows of data with Column A being the key identifier in worksheets
SPR1 and SPR2 inside a work book. Reading one of the threads below, I am
using the following formula in SPR3 (3rd worksheet in the same workbook) to
identify a match between SPR2 and SPR1 from Column A in both columns:

=IF(NOT(ISNUMBER(MATCH(spr2!A1,spr1!A:A,0))),"",I NDEX(spr1!A:A,MATCH(spr2!A1,spr1!A:A,0)))

Is there any way to bring the entire Row of data in SPR1 and SPR2 (assuming
they are the same) instead of just column A into SPR3?

You cannot bring an entire row using one formula.

Have you tried changing A:A to $A:$A before copying across?


Gord

On Tue, 6 May 2008 10:52:01 -0700, vrk1 wrote:

That did not work.

Please note that Column A is the matching column. I want to bring the rest
of the columns in SPR3 that ties with Column A.

Any other suggestions?

"Gord Dibben" wrote:

Drag/copy the formula across to end of row.


Gord Dibben MS Excel MVP

On Tue, 6 May 2008 07:25:00 -0700, vrk1 wrote:

Hi,

I have rows of data with Column A being the key identifier in worksheets
SPR1 and SPR2 inside a work book. Reading one of the threads below, I am
using the following formula in SPR3 (3rd worksheet in the same workbook) to
identify a match between SPR2 and SPR1 from Column A in both columns:

=IF(NOT(ISNUMBER(MATCH(spr2!A1,spr1!A:A,0))),"",I NDEX(spr1!A:A,MATCH(spr2!A1,spr1!A:A,0)))

Is there any way to bring the entire Row of data in SPR1 and SPR2 (assuming
they are the same) instead of just column A into SPR3?

Thanks for writing back again; I tried changing the formula to read $A:$A and
pasted it across the row in SPR3 -did not work still.

If this can be accomplished using a Macro, I am open to that too -- I just
don't know how.

Any help would be appreciated. Thanks

"Gord Dibben" wrote:

You cannot bring an entire row using one formula.

Have you tried changing A:A to $A:$A before copying across?


Gord

On Tue, 6 May 2008 10:52:01 -0700, vrk1 wrote:

That did not work.

Please note that Column A is the matching column. I want to bring the rest
of the columns in SPR3 that ties with Column A.

Any other suggestions?

"Gord Dibben" wrote:

Drag/copy the formula across to end of row.


Gord Dibben MS Excel MVP

On Tue, 6 May 2008 07:25:00 -0700, vrk1 wrote:

Hi,

I have rows of data with Column A being the key identifier in worksheets
SPR1 and SPR2 inside a work book. Reading one of the threads below, I am
using the following formula in SPR3 (3rd worksheet in the same workbook) to
identify a match between SPR2 and SPR1 from Column A in both columns:

=IF(NOT(ISNUMBER(MATCH(spr2!A1,spr1!A:A,0))),"",I NDEX(spr1!A:A,MATCH(spr2!A1,spr1!A:A,0)))

Is there any way to bring the entire Row of data in SPR1 and SPR2 (assuming
they are the same) instead of just column A into SPR3?