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?