In cell C$4,$ using the Asset ID in C$3,$ use HLOOKUP to find the Employee ID assigned to C$3\text{'}$s asset ID$.$ Then nest that formula into a VLOOKUP formula as the lookup value to find the name of the assigned employee. Use the following named ranges.

Name

Range

Assignment $=$Assignment$|$$A$$1$:$P$$3$

Emplovees