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

New Contributor

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 help me......not working for largedata

4 Replies

Hi @raghulck,

 

Your formula should read as below.

 

 

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

 

 

FarazShaikh_0-1637659468867.png

 

 

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.

@Faraz Shaikhcan u help to  type stepby step.. 

unable to followpls...

Excel 365 with Power Query.

Query testing status.

No formulas, no VBA macro.

US ified for max community utility.

https://www.mediafire.com/file/9czyi5ia3kz2ji9/11_23_21.xlsx/file

https://www.mediafire.com/file/3hkkf6n6brn7gsr/11_23_21.pdf/file