Oct 15 2019 12:02 PM
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?
Oct 15 2019 02:34 PM
You may use VLOOKUP or INDEX/MATCH tp pick names up based on computers' numbers.
Oct 17 2019 05:17 AM
@Sergei Baklan How do you do that please?
Oct 17 2019 06:21 AM
Could you please provide small sample file? On concrete data it's easier to illustrate the formula.
Oct 17 2019 06:30 AM
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