VLOOKUP Function help

--------------------------------------------------------------------------------

Hello, I have to do an assignment which requires me to use the VLOOKUP function. I have always had trouble with this function and any help would be greatly appreciated. Here are what the instructions state:

"On the Salespeople Worksheet, the Average Function should be used in Column “Av Emp” , the Vlookup function should be used in the Column “Total Sales” (to retrieve data and add together both Appliance and Nonappliance State Totals), and then the division of the latter two, for each row, provides the “Sales/Emp."

So I understand I have three worksheets, named Appliance, Nonappliance, and Salespeople. I am creating the VLOOKUP function in the Salespeople worksheet, but need to retreive information from the State Totals columns in the Appliance and Nonappliance worksheets. I am just not sure what values go in the parts of the function, though. There are different states in the horizontal rows, like CT, MA, etc, so if I wanted to combine the State Totals for CT in the Appliance and Nonappliance worksheets, how would I turn that into a VLOOKUP function?

Attached is the Workbook!

To anyone who can help direct me in the right way, thank you so, so very much!

Duplicate post