Forum Discussion
smurgallis
Feb 07, 2023Copper Contributor
Using IF to return table data
I'm working with a workbook that contains multiple sheets. Each sheet has a table with two columns, "Task" and "Cat", and each table is named (TASK12, TASK19, TASK116, etc.). Both columns contain tex...
OliverScheurich
Feb 07, 2023Gold Contributor
If i correctly understand what you want to do you can use VLOOKUP or INDEX and MATCH for this. If you work with Office365 or Excel 2021 you can apply XLOOKUP as well.
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft Support