Table Results- Formula Help

I am trying to get a master table with lookups from two other tables to produce a specific output.


I swear I am missing something silly here…

HI Tim,

Welcome to CODA.

But you must please provide a little bit more info. It can get a little tricky sometimes to link tables together, depending on the needs.

Here is a sample doc for what I am trying to replicate. I would like to use the likelihood and impact fields as drop downs which then would output a dynamically changing risk indicator based on those inputs.

I tried sharing the doc, but I can’t due to domain issues

Hi @Tim_Reed,

Have a look at this and tell me if it works for you:



Thanks! That will do nicely.

1 Like