How To Find "x" In A Column And Show "y" In Cell "z"

[rcane]

thanks that worked great!

HOWEVER, (always is), how do I spread that over many (500+) row
without the references to the other sheet increasing?

Can you keep it on the same "table" in that other sheet

 

[Myrna Larson]

Try looking up Absolute Reference in Help.

 

[JulieD]

Hi

you're welcome

sorry should have written the formula as
=IF(ISNA(MATCH(A2,Sheet2!$A$3:$A$100,0)),"",B2)

and as Myrna said .. have a look at "absolute and relative cell addressing"
in help for details on what the $ do.

Cheers
JulieD