Forum Discussion

michaelhilland's avatar
michaelhilland
Copper Contributor
Apr 02, 2020
Solved

Excel Formula Help

Hi,   I have two tabs. Each tab possible has the same information in a number of rows and columns. I am wanting to check if one row in tab one matches any row in tab two. For example:   Tab One ...
excel
Formulas and Functions
office 365
training
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Apr 03, 2020

    michaelhilland You indicate that you are on Office365, so you might have access to the new FILTER function. I copied your tables and pasted them in a new sheet (all in one tab) with some color coding to visualise the relationships between the two tables. Please see attached. The results are in column I.

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Apr 03, 2020

michaelhilland You indicate that you are on Office365, so you might have access to the new FILTER function. I copied your tables and pasted them in a new sheet (all in one tab) with some color coding to visualise the relationships between the two tables. Please see attached. The results are in column I.

michaelhilland's avatar
michaelhilland
Copper Contributor
Apr 03, 2020

Riny_van_Eekelen Thats amazing, thank you. It worked perfectly. I have never heard of the filter function! 

 

Have a great day and keep safe 🙂