How do i create an IF func to return values from another spreadshe

[ALF2008]

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.

 

[Mike H]

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

 

[Jacob Skaria]

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