Part $4$: Credit Line field

Add the data for credit line to the $$Full Set$$ worksheet. A minimum credit line of $$2,000$ has been established, so that even if the customer has a credit line of $$0$ it is changed to $$2,000.$ Use the VLOOKUP$()$ function to put this data into the $$Full Set$$ worksheet, using the Credit Line Lookup table in the Lookups worksheet.

If you do it correctly, at first there will be three errors $($N$/$A$$ values in three cells$).$ That$$s because there is a problem with the data in the Credit Line Lookup table.

Make the necessary change to the data in that table to correct the issue so that Credit Line data appears for all the customers.