find corresponding value in another sheet

[Harvey Waxman]

I have sheet 1 with 2 columns, A and B and 100 rows

I have another sheet 2 with 2 columns but just 10 rows.

When I find a value in a row of column A of sheet 2 (say A6) that matches a
value in column A of sheet 1 (say A45) I'd like to paste the value found in B6
of sheet 2 into B45 of sheet 1.

Did I make that confusing enough?

I need a formula in column B of sheet 1 that can do this for me. Possible?



--
Harvey Products makers of Dinghy Dogs
The Boater's Best Friend
http://www.dinghydogs.com
Ladies' handbags and accessories
http://www.deducktibles.com
Remove thefrown to email me

 

[Harvey Waxman]

I have sheet 1 with 2 columns, A and B and 100 rows

I have another sheet 2 with 2 columns but just 10 rows.

When I find a value in a row of column A of sheet 2 (say A6) that matches a
value in column A of sheet 1 (say A45) I'd like to paste the value found in
B6
of sheet 2 into B45 of sheet 1.

Did I make that confusing enough?

I need a formula in column B of sheet 1 that can do this for me. Possible?

Maybe I can make it a bit easier. If I find that there is an equal value
anywhere in column A of sheet 2 to I'd like to place a simple "comment" into
sheet 1 in the column B of the row containing the equal value.

In the above example, Sheet 1 B45 could have "comment" instead of a value from
B6 in sheet 2.

thanks


--
Harvey Products makers of Dinghy Dogs
The Boater's Best Friend
http://www.dinghydogs.com
Ladies' handbags and accessories
http://www.deducktibles.com
Remove thefrown to email me

 

[JE McGimpsey]

I have sheet 1 with 2 columns, A and B and 100 rows

I have another sheet 2 with 2 columns but just 10 rows.

When I find a value in a row of column A of sheet 2 (say A6) that matches a
value in column A of sheet 1 (say A45) I'd like to paste the value found in
B6
of sheet 2 into B45 of sheet 1.

Did I make that confusing enough?

I need a formula in column B of sheet 1 that can do this for me. Possible?

One way:

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

 

[JE McGimpsey]

Maybe I can make it a bit easier. If I find that there is an equal value
anywhere in column A of sheet 2 to I'd like to place a simple "comment" into
sheet 1 in the column B of the row containing the equal value.

In the above example, Sheet 1 B45 could have "comment" instead of a value
from
B6 in sheet 2.

One way:

B2: =IF(ISNA(MATCH(A2,Sheet2!A:A,FALSE)),"","comment")

or, equivalently:

B2: =IF(COUNTIF(Sheet2!A:A,A2),"comment","")

 

[Harvey Waxman]

One way:

B2: =IF(ISNA(MATCH(A2,Sheet2!A:A,FALSE)),"","comment")

or, equivalently:

B2: =IF(COUNTIF(Sheet2!A:A,A2),"comment","")

Thanks yet once again. Perfect.


--
Harvey Products makers of Dinghy Dogs
The Boater's Best Friend
http://www.dinghydogs.com
Ladies' handbags and accessories
http://www.deducktibles.com
Remove thefrown to email me