Forum Discussion
Mammerman
Sep 01, 2021Copper Contributor
Help determining which Excel formula to use
Hi! I could use some help determining the best formula to achieve certain results. I have 1 workbook that contains 2 sheets. Both sheets contain a column "Content Title" with varying amounts of d...
Detlef_Lewin
Sep 01, 2021Silver Contributor
Use XLOOKUP().
https://support.microsoft.com/en-us/office/xlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929
- Juliano-PetrukioSep 01, 2021Bronze Contributor
=IFERROR(INDEX(Sheet2!B2:B4,MATCH(A2,Sheet2!A2:A4,0),1),"Not Found")
=IFERROR( INDEX( Sheet2!B2:B4 ), { MATCH( A2 ), { Sheet2!A2:A4 ), { 0 ) ), { 1 ) ), { "Not Found" )