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