Forum Discussion
Using an If(countifs formula and returning a value in an adjacent cell
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
