I am currently working on an Excel sheet (attached) where I need assistance with the VLOOKUP function. Specifically, I am trying to retrieve the Site Name from the Customer Info sheet based on the Customer ID already listed in the Vendor Info sheet.
Attached is the Excel file with two sheets: Customer Info and Vendor Info. The Customer Info sheet contains Customer IDs and corresponding Site Names. In the Vendor Info sheet, I have a list of Customer IDs for which I need to retrieve the respective Site Names using the VLOOKUP function.
Could someone kindly provide guidance or an example of how to set up the VLOOKUP formula correctly in this scenario? Any assistance would be greatly appreciated.
Thank you in advance for your help.
Attached is the Excel file with two sheets: Customer Info and Vendor Info. The Customer Info sheet contains Customer IDs and corresponding Site Names. In the Vendor Info sheet, I have a list of Customer IDs for which I need to retrieve the respective Site Names using the VLOOKUP function.
Could someone kindly provide guidance or an example of how to set up the VLOOKUP formula correctly in this scenario? Any assistance would be greatly appreciated.
Thank you in advance for your help.