Is there a way of doing table lookup?

Example:

inv_header(id,inv_date,…,client_id,…)

clients (client_id,name).

Is it possible to search for the client name and then update client_id in the inv_header table?

Thanks in advance,

Alexandre