Append the appropriate value for the field Lens Type in the file primolenses to each record in the file primoappts usinng XLOOKUP Excel function. Save your results as a file under the name primodata.xlsx$.$

$($a$)$ Search the file primodata that you created for missing values for the Lens Type field.

The file primodata.xlsx is missing

$0$

records for the field Lens Type.

$($b$)$ Search the file primodata that you created for duplicate records. If your answer is zero, enter $"0."$

The file primodata.xlsx contains

$0$

duplicate record$($s$).$