Forum Discussion
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...
SergeiBaklan How do you do that please?
Could you please provide small sample file? On concrete data it's easier to illustrate the formula.
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