Question

Enter a vlookup() function that will find the state each customer lives in (based on the customerid (column b) in the rawdata worksheet).

Answer 1

You can use the VLOOKUP() function in Excel to find the state each customer lives in based on the customer ID.

Step-by-step explanation:

To find the state each customer lives in based on the customer ID in the 'rawdata' worksheet, you can use the VLOOKUP() function in Excel. Here is an example of the formula:

=VLOOKUP(B2, rawdata!A:B, 2, FALSE)

In this formula, 'B2' is the cell containing the customer ID, 'rawdata!A:B' is the range containing the customer ID and state columns in the 'rawdata' worksheet, '2' indicates that the state column is the second column in the range, and 'FALSE' ensures an exact match.

Make sure to adjust the formula according to your specific worksheet and data layout.

Answer 2

The VLOOKUP function is used to find the state each customer lives in based on their customer ID in Excel.

Step-by-step explanation:

The VLOOKUP function in Excel is used to search for a specific value in the first column of a data set and then return a corresponding value from a different column. To find the state each customer lives in based on their customer ID, you would use the following VLOOKUP function:

=VLOOKUP(B2, rawdata!$B$2:$C$100, 2, FALSE)

This formula assumes that the customer ID is in column B of the 'rawdata' worksheet, and the state is in column C. Adjust the range 'rawdata!$B$2:$C$100' based on the actual location of the customer ID and state columns in your worksheet.