Forum Discussion
Matching Excel cells by column
Hi, I'm trying to do what I thought was a simple match, but it looks to be a little more complicated than I thought. I have two lists, each with their own column & respective ID #. For example, "...
You can use https://support.office.com/en-us/article/filter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759?NS=EXCEL&Version=90&SysLcid=1033&UiLcid=1033&AppVer=ZXL900&HelpId=xlmain11.chm60662&ui=en-US&rs=en-US&ad=US function.
Apply filters on columns A:B and C:D with condition column A and C ="Microsoft"