Using an If(countifs formula and returning a value in an adjacent cell

Copper Contributor

Hi, 

 

I hope someone can help me with this  Formula

 

=IF(COUNTIFS('2018'!$B$2:$B$2125,B2)>0,'2018'!$C$2:$C$2125,"No")

 

I am looking for B2 in the sheet 2018.  If found I want to return the value from column C in that sheet. 

The formula is returning a number from column C but it is not the adjacent cell to the match.

 

Can someone help please?

 

Berniews

 

2 Replies
Try =IFERROR(VLOOKUP(B2,'2018'!$B$2:$C$2125,2,FALSE),"No")
Hi Hans,

Thank you that worked perfectly. It is easy when you know how :)

Cheers
Bernie