Trying to find Matches and Give a Result
 

I want to compare a cell in Sheet1, columnA with all cells in Sheet2, column
A. If a match is found, place the information found in column B of the
match(Sheet1) to colum B of sheet2. If no match is found, leave blank.

Please Help.

Trying to find Matches and Give a Result
 

Try in B2:

=ISNA(VLOOKUP(A2,Sheet2!$A:$B,2,0)),"",VLOOKUP(A2, Sheet2!A:B,2,0))

Copy down.

HTH


"cheryl" wrote:

I want to compare a cell in Sheet1, columnA with all cells in Sheet2, column
A. If a match is found, place the information found in column B of the
match(Sheet1) to colum B of sheet2. If no match is found, leave blank.

Please Help.

Trying to find Matches and Give a Result
 

Ths looks easier than the -IF(ISERROR... formula that I started off with
however I am getting a message that this formula contains errors too.

"Toppers" wrote:

Try in B2:

=ISNA(VLOOKUP(A2,Sheet2!$A:$B,2,0)),"",VLOOKUP(A2, Sheet2!A:B,2,0))

Copy down.

HTH


"cheryl" wrote:

I want to compare a cell in Sheet1, columnA with all cells in Sheet2, column
A. If a match is found, place the information found in column B of the
match(Sheet1) to colum B of sheet2. If no match is found, leave blank.

Please Help.

Trying to find Matches and Give a Result
 

=IF(ISNA(VLOOKUP(A2,Sheet2!$A:$B,2,0)),"",VLOOKUP( A2,Sheet2!A:B,2,0))

sorry ...typo

"cheryl" wrote:

Ths looks easier than the -IF(ISERROR... formula that I started off with
however I am getting a message that this formula contains errors too.

"Toppers" wrote:

Try in B2:

=ISNA(VLOOKUP(A2,Sheet2!$A:$B,2,0)),"",VLOOKUP(A2, Sheet2!A:B,2,0))

Copy down.

HTH


"cheryl" wrote:

I want to compare a cell in Sheet1, columnA with all cells in Sheet2, column
A. If a match is found, place the information found in column B of the
match(Sheet1) to colum B of sheet2. If no match is found, leave blank.

Please Help.

Trying to find Matches and Give a Result
 

Beautiful- thank you.

"Toppers" wrote:

=IF(ISNA(VLOOKUP(A2,Sheet2!$A:$B,2,0)),"",VLOOKUP( A2,Sheet2!A:B,2,0))

sorry ...typo

"cheryl" wrote:

Ths looks easier than the -IF(ISERROR... formula that I started off with
however I am getting a message that this formula contains errors too.

"Toppers" wrote:

Try in B2:

=ISNA(VLOOKUP(A2,Sheet2!$A:$B,2,0)),"",VLOOKUP(A2, Sheet2!A:B,2,0))

Copy down.

HTH


"cheryl" wrote:

I want to compare a cell in Sheet1, columnA with all cells in Sheet2, column
A. If a match is found, place the information found in column B of the
match(Sheet1) to colum B of sheet2. If no match is found, leave blank.

Please Help.

Trying to find Matches and Give a Result
 

Works Great! Thank you.

"Toppers" wrote:

=IF(ISNA(VLOOKUP(A2,Sheet2!$A:$B,2,0)),"",VLOOKUP( A2,Sheet2!A:B,2,0))

sorry ...typo

"cheryl" wrote:

Ths looks easier than the -IF(ISERROR... formula that I started off with
however I am getting a message that this formula contains errors too.

"Toppers" wrote:

Try in B2:

=ISNA(VLOOKUP(A2,Sheet2!$A:$B,2,0)),"",VLOOKUP(A2, Sheet2!A:B,2,0))

Copy down.

HTH


"cheryl" wrote:

I want to compare a cell in Sheet1, columnA with all cells in Sheet2, column
A. If a match is found, place the information found in column B of the
match(Sheet1) to colum B of sheet2. If no match is found, leave blank.

Please Help.