Hi

I have a set of data as followsSheet One

No Name

1 John

2 Alex

3 Sue

4 MarySheet 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 meMany thanks

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

Ask Your Question

Weekly Poll

Did you buy anything on Amazon's Prime Day?

Discuss in The Lounge

Poll History