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

[Tgrooby]

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 computer. I am trying to get a cell on tab 2 to look for the computer number shown on tab 2 in tab 1 and auto populating the name next to that computer number in tab 2. 

images show the tabs. 

Can i get tab 2 to auto fill the correct name next to the computer number?

[#2]

@Tgrooby 

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

[#3]

@Sergei Baklan How do you do that please?

[#4]

@Tgrooby 

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

[#5]

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