Forum Discussion

Tgrooby's avatar
Tgrooby
Copper Contributor
Oct 15, 2019

Excel help - auto look up and match cell whilst filling in another cell

Hello. I have a file that has two tabs. On one tab there is a list of computer numbers with names next to them. On the second tab i have a list of computer numbers and a list of software on that com...
excel
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Oct 15, 2019

Tgrooby 

You may use VLOOKUP or INDEX/MATCH tp pick names up based on computers' numbers.

  • Tgrooby's avatar
    Tgrooby
    Copper Contributor
    Oct 17, 2019

    SergeiBaklan How do you do that please?

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Oct 17, 2019

      Tgrooby 

      Could you please provide small sample file? On concrete data it's easier to illustrate the formula.

      • Tgrooby's avatar
        Tgrooby
        Copper Contributor
        Oct 17, 2019

        See attached spread sheet. I am trying to get excel to match the computer numbers from tab 2 on tab 1 and fill in the cells that are yellow with their name

Resources