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

R

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
 
J

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
 
Top