Forum Discussion

raghulck's avatar
raghulck
Copper Contributor
Nov 23, 2021

To find match data from 2 sheets ..............

i have employees names and id numbers in sheet 1 and employees completed particular training in the  second sheet i used =isnumber(match.xx,xxx,xxx,true) this formula its notworking can anyoneone hel...
excel
Excel for web
ExcelExciting's avatar
ExcelExciting
MVP
Nov 23, 2021

Hi raghulck,

 

Your formula should read as below.

 

 

=ISNUMBER(MATCH(D2,Sheet2!$D$2:$D$16,0))

 

 

 

 

Regards, Faraz Shaikh | Microsoft MVP, MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official/Best Answer & like it to help the other members find it more.

  • raghulck's avatar
    raghulck
    Copper Contributor
    Nov 23, 2021

    ExcelExcitingcan u help to  type stepby step.. 

    • raghulck's avatar
      raghulck
      Copper Contributor
      Nov 23, 2021
      unable to followpls...

Resources