Hope this will be useful to someone (have been searching for the solution for hours!). The function to use is #+TBLFM: $3='(org-lookup-first $2 '(remote(FOO,@2$1..@>$1)) '(remote(FOO,@2$2..@>$2))) Found it by reading this answer which links to the org lookup functions documentation, which in turn links to useful examples in Worg.

Only top voted, non community-wiki answers of a minimum length are eligible