SOLVED

Struggling with Vlookup / Index & Match

Copper Contributor

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

3 Replies
If 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
best response confirmed by AmbrosiaT (Copper Contributor)
Solution

@AmbrosiaT 

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.

@OliverScheurich THANK YOU!!!! This was giving me brain damage. Thank you so very much!

1 best response

Accepted Solutions
best response confirmed by AmbrosiaT (Copper Contributor)
Solution

@AmbrosiaT 

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.

View solution in original post