(1) Use Xlookup to pull the information associated with the Distributor name. Replace error with "No information" if it is a text and replace error with 0 if it is a number. (Though Distributor IDs are numbers, they should be treated as text) Distributor Name Distributor ID Unit Price Revenue Zahir Fields Rama Goodwin Imogene Bradshaw Tony Parker Tad Mack Johns Hopkins Nyssa Quinn Total Revenue $0.00 (2) What is the advantage of XLooup over VLookup