can I use the IF formula to create an INDEX MATCH type formula?
If not, is there another function I can use to generate an INDEX MATCH result from connected records?
What I want to have is a value (the Priority Ranking number) automatically generated if the related column has a specified single selection choice (ie my selection is a Priority Descriptor such as CRITICAL AND URGENT; if that is the selection, I want the next column PRIORITY RANKING to generate the figure 1.
NB: The active Table is a Task table; I am using the single selection field as a related Record from the Priority Descriptor Table to give me the drop down values and the Priority Ranking is aligned with the Descriptors on the Priority Descriptor Table.
The flow is Task Name (fixed field in the Task Table)/Priority Descriptor (single selection field from the related record) / Priority Ranking (automatically generated based on the drop down selection)