Forum Discussion

Christina Kang's avatar
Christina Kang
Copper Contributor
Jul 10, 2017
Solved

Returning value based on a text list

Hi everyone,   I have a list of 50 distinct accounts. There are three account managers (i.e., Team 1, Team 2, Team 3) in my organization each of whom is assigned to a book of distinct accounts (i.e...
Formulas & Functions
Need Help
  • IngeborgHawighorst's avatar
    IngeborgHawighorst
    Jul 10, 2017

    Hello,

     

    You can use the Vlookup function for this. Consider the following screenshot:

    The account list in columns E and F shows which team an account belongs to.

    When an account is entered into cell A2, the formula in B2 looks up that account in column E and returns the team name from column F

     

    The formula, as seen in the formula bar is

     

    =VLOOKUP(A2,$E$2:$F$14,2,FALSE)

    The formula can then be copied down.

IngeborgHawighorst's avatar
IngeborgHawighorst
MVP
Jul 10, 2017

Hello,

 

You can use the Vlookup function for this. Consider the following screenshot:

The account list in columns E and F shows which team an account belongs to.

When an account is entered into cell A2, the formula in B2 looks up that account in column E and returns the team name from column F

 

The formula, as seen in the formula bar is

 

=VLOOKUP(A2,$E$2:$F$14,2,FALSE)

The formula can then be copied down.

Resources