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

Question

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.&nbsp;&nbsp;images show the tabs.&nbsp;&nbsp;Can i get tab 2 to auto fill the correct name next to the computer number?

sergeibaklan · Answer

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

tgrooby · Answer

SergeiBaklan&nbsp;How do you do that please?

sergeibaklan · Answer

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

tgrooby · Answer

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

Forum Discussion

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

4 Replies

Resources