Search formula

A

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
 
F

Fred Exley

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

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

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)
 
Top