Is there a comparable Formula to use for performing actions similar to a VLOOKUP or INDEX-MATCH?
I'm hoping to LOOKUP a value from another Table based on the field value within another Table.
An example:
If the user selects a Session from the following options: Session A, Session B, Session C, then I want to be able to search the other table that contains all the Session start times (Start time A, Start time B, Start time C) and return the candidates start time. I currently have to pull in all the records from the other table and perform an IF statement to get the same results, but I feel this isn't a scalable approach.