Forum Discussion
AmbrosiaT
Jun 17, 2024Copper Contributor
Struggling with Vlookup / Index & Match
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
See 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.
- OliverScheurichGold Contributor
See 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.
- AmbrosiaTCopper Contributor
OliverScheurich THANK YOU!!!! This was giving me brain damage. Thank you so very much!
- AmbrosiaTCopper ContributorIf both Position and Job match, I need the code from 'Export (2)' Column 4.
file:///C:/Users/Ambrosia.Tisdall/Downloads/Report%205.5.2024.xls