[sql table="b" unique_lookup_field="c" lookup_value="d" return_field="a"] If a table or column name has a space or other unusual character in it, wrap it in `backticks`. If a value contains a space or ...

For this, lookup functions can be used: they search for a value in a range and return a corresponding row or column. Lookup functions are common: according to recent research the VLOOKUP is the fifth ...