kimknguyen
Member
Help! I have a big table with names (6000 records) and a smaller table (384 record) with names. How do I identify which names on the BIG table are on the SMALL table? Thanks
Hi Fluff13,How about, in D5 copied down
=IFERROR(INDEX(Table3[Date Back],MATCH(B5,Table3[Name],0)),"")
Hi Alandsidman,An alternative solution is to use Power Query and join the two tables on the name. Attached is the file with that solution.