Jun 17 2024 10:48 AM
I need to match 2 columns of data to another sheet, then return another column of data only if they both match. I will attach a file in the reply.
Thank you,
Ambrosia
64-bit operating system, x64-based processor
Windows 10 Enterprise
Microsoft 365 Apps for enterprise
Version 2308
Jun 17 2024 10:54 AM
Jun 17 2024 12:06 PM
SolutionSee attached sample file. The formulas must be entered as arrayformulas with ctrl+shift+enter if someone doesn't work with Office 365 or Excel for the web or Excel 2021.
Jun 17 2024 12:26 PM
@OliverScheurich THANK YOU!!!! This was giving me brain damage. Thank you so very much!
Jun 17 2024 12:06 PM
SolutionSee attached sample file. The formulas must be entered as arrayformulas with ctrl+shift+enter if someone doesn't work with Office 365 or Excel for the web or Excel 2021.