Oct 11 2021 02:59 AM
Hi All
i have a sheet in which i have two columns A and B.
Column A has 4000 entries, Column B has 250 entries. I want to compare Column B with Column A and want to fetch matching entries of Column B from Column A. Will the below vlookup syntax help me. in other words lets say Column B has 250 entries and matching entries of Column B with Column A can be 100.
=FILTER(VLOOKUP(B1:B250,A:A,1,FALSE),NOT(ISNA(VLOOKUP(B1:B250,A:A,1,FALSE))))
Oct 11 2021 03:25 AM