About the VLOOKUP function in Microsoft Excel.?

In the upper left area of your window, to the left of the command line, there is a pull down arrow. Click on the arrow and pick the name Customers. This will take you to the named group of cells and highlight them. Click on the side of the highlight and drag this edge to include the cells you want VLOOKUP to search. You might need to rearrange your source data to allow the addresses be in the right area to be included. Good luck. I wish I could attach an Excel for you to see how this function really works, but I can't.