Solved Excel Question - match

November 24, 2016 at 21:21:45
Specs: Windows 10, i5 /4GB
I have a set of data as follows

Sheet One

No Name
1 John
2 Alex
3 Sue
4 Mary

Sheet Two
If i type in a number (eg 1 to 4) in a cell in Sheet two, it can match it with the number in Sheet one and display the name for me

Many thanks

See More: Excel Question - match

Report •

November 24, 2016 at 21:26:15
✔ Best Answer
A VLOOKUP() should get you your answer.
Somthing like:

On Sheet 2 ,cell A1 enter the formula:


On Sheet 2, cell B1 enter your target number.

See how that works for you.


Report •
Related Solutions

Ask Question