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