Solved Excel Question - match

November 24, 2016 at 21:21:45
Specs: Windows 10, i5 /4GB
Hi
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 •

#1
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:

=VLOOKUP(B1,Sheet1!A1:B5,2,0)

On Sheet 2, cell B1 enter your target number.

See how that works for you.

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question