well i have a situation at my hand
i have two sheets. one has a list of 2000 item and the other has 375
i want to compare the sheetA 375 one with SheetB 2000.
if the column A matches the columnA of sheet2 then copy the values from
sheetB from column B thru F in to sheet A F thru L can someone please tell
me how to do this or if someone can write a macro for this as i dont know at
all how to write those macros

Use the VLOOKUP Function

In SheetA go to cell F2 and enter:

=VLOOKUP($A2,'SheetB'$A$2:$F$2000,2,FALSE)

Copy this formula into cell G2, H2, I2, J2. Change the third value (ie-2
above) to appropriate column number to pull (ie-G2 would be 3, H2 would be 4,
etc). If it matches up to something in the other sheet, it will pull the
appropriate value.

"Arain" wrote:

well i have a situation at my hand
i have two sheets. one has a list of 2000 item and the other has 375
i want to compare the sheetA 375 one with SheetB 2000.
if the column A matches the columnA of sheet2 then copy the values from
sheetB from column B thru F in to sheet A F thru L can someone please tell
me how to do this or if someone can write a macro for this as i dont know at
all how to write those macros

well the thing is if column A in sheet one matches in Sheet B i need
everything i
related to that to be copied immediately in to respective fields in sheet A
in the columns i f thru l as they are the right info.
"Mallasch" wrote:

Use the VLOOKUP Function

In SheetA go to cell F2 and enter:

=VLOOKUP($A2,'SheetB'$A$2:$F$2000,2,FALSE)

Copy this formula into cell G2, H2, I2, J2. Change the third value (ie-2
above) to appropriate column number to pull (ie-G2 would be 3, H2 would be 4,
etc). If it matches up to something in the other sheet, it will pull the
appropriate value.

"Arain" wrote:

well i have a situation at my hand
i have two sheets. one has a list of 2000 item and the other has 375
i want to compare the sheetA 375 one with SheetB 2000.
if the column A matches the columnA of sheet2 then copy the values from
sheetB from column B thru F in to sheet A F thru L can someone please tell
me how to do this or if someone can write a macro for this as i dont know at
all how to write those macros