Can someone help me with a formula to reference another clay table?

Search for Clay lookup in the list of enrichments.

Thanks - for some reason it is returning an error when I use 'equals' but works when using 'contains'... They are the exact same values on both sheets

Look for white text (like spaces and tabs) in the names.

There are none that I can see...

Can't help further without looking at the table.

https://app.clay.com/workspaces/236278/tables/t_Oe84jr6Y4hfC/views/gv_HBnYUS5U6AR2

reference table: https://app.clay.com/workspaces/236278/tables/t_f8MQf32XAhNL/views/gv_LBC1DSil1GMp