Forum Discussion

Berniews's avatar
Berniews
Copper Contributor
Nov 17, 2020

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 v...
excel
HansVogelaar's avatar
HansVogelaar
MVP
Nov 17, 2020
Try =IFERROR(VLOOKUP(B2,'2018'!$B$2:$C$2125,2,FALSE),"No")
  • Berniews's avatar
    Berniews
    Copper Contributor
    Nov 17, 2020
    Hi Hans,

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

    Cheers
    Bernie

Resources