2 Sheets: 1 data, 1 form..

I wish to enter data (or select from drop ) into a cell on Sheet One that
when it matches the column entry in Sheet2 Column A, it will take the data in
that matching row on Sheet 2 and populate other cells in Sheet One..

Logically sounds easy, but not knowledgeable enough about Excel to script..

Thanks, in advance..

if your data in sheet 2 is coulumn A:Z
in sheet 1 B1 enter
=if(iserror(vlookup($A1,'Sheet2'!$A:Z$,column(),0) ),"",vlookup($A1,'Sheet2'!$A:Z$,column(),0))
copy and paste over to column Z and down as far you need

"DeadpanDad" wrote:

2 Sheets: 1 data, 1 form..

I wish to enter data (or select from drop ) into a cell on Sheet One that
when it matches the column entry in Sheet2 Column A, it will take the data in
that matching row on Sheet 2 and populate other cells in Sheet One..

Logically sounds easy, but not knowledgeable enough about Excel to script..

Thanks, in advance..

Thanks bj.. Shall give it a shot !!

"bj" wrote:

if your data in sheet 2 is coulumn A:Z
in sheet 1 B1 enter
=if(iserror(vlookup($A1,'Sheet2'!$A:Z$,column(),0) ),"",vlookup($A1,'Sheet2'!$A:Z$,column(),0))
copy and paste over to column Z and down as far you need

"DeadpanDad" wrote:

2 Sheets: 1 data, 1 form..

I wish to enter data (or select from drop ) into a cell on Sheet One that
when it matches the column entry in Sheet2 Column A, it will take the data in
that matching row on Sheet 2 and populate other cells in Sheet One..

Logically sounds easy, but not knowledgeable enough about Excel to script..

Thanks, in advance..