Minor corrections with cell references.

The below formula will check whether the entry in Sheet1 cell A1 exists in
Sheet2 ColA . If a match is found it would return the ColB value of the
corresponding entry from Sheet2.

=IF(COUNTIF(Sheet2!A:A,A1),VLOOKUP(A1,Sheet2!A:B,2 ,0),"")


If this post helps click Yes
---------------
Jacob Skaria


"Mike H" wrote:

Hi,

Your question isn't clear but this returns a match if there is one or a
blank if there isn't

=IF(COUNTIF(Sheet2!A2:A12,A1)0,VLOOKUP(A1,Sheet2! A1:B11,2,FALSE),"")

Mike

"ALF2008" wrote:

Hi

I have done a VLookup and want to return the value in one spreadsheet into
another when the vlookup returns a match. Can anybody please help as I am
going round in circles.