Search formula

[Adam]

Hi all

I have an excel sheet with two headings
under the one heading is 1 to 1000
In the column next to the number is a word.
Is there away i can do a search so the user puts the
number say 5 and it shows whats in the cell??

All help appreciated

Thanks

 

[Ron de Bruin]

Hi Adam

Use the VLookup function
See the Excel help for examples

 

[Fred Exley]

Assuming your numbers 1 to 1000 are in range a2:a1001 then:

=LOOKUP(5,A2:A1001,B2:B1001)

 

[Ragdyer]

If I understand what you're looking for, try Vlookup().

Column A is numbers.
Column B is words.

In C1 enter the number.
Enter this formula in D1:

=VLOOKUP(C1,A1:B100,2,0)