DB reference

smittycft99 · May 9th, 2002, 02:09 PM

This is what I have
D1 D2
1 cat
2 dog
3 mouse
4 hello
5 table
A1 - if someone types in the number 3 in A1 I want mouse to populate A2

Brian from Maui · May 9th, 2002, 02:21 PM

In A2

=VLOOKUP(a1,range,2)

smittycft99 · May 9th, 2002, 02:36 PM

Thank you very much

Bert · May 9th, 2002, 03:24 PM

don't forget to put false in the end in your formula, otherwise you will get problems with sorting

Mark W. · May 9th, 2002, 03:32 PM

Quote:

On 2002-05-09 13:09, smittycft99 wrote:
This is what I have
D1 D2
1 cat
2 dog
3 mouse
4 hello
5 table
A1 - if someone types in the number 3 in A1 I want mouse to populate A2

You table description is somewhat lacking. In the absense of more info I fail to see why a sequential lookup is required when you could directly access the desired value using...

=INDEX(D2:D6,A1)

...where D2:D6 contains {"cat";"dog";"mouse";"hello";"table"}.

[ This Message was edited by: Mark W. on 2002-05-09 14:33 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 9th, 2002, 02:09 PM	#1
smittycft99 Board Regular Join Date: Apr 2002 Posts: 130	This is what I have D1 D2 1 cat 2 dog 3 mouse 4 hello 5 table A1 - if someone types in the number 3 in A1 I want mouse to populate A2

May 9th, 2002, 02:21 PM	#2
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	In A2 =VLOOKUP(a1,range,2)

May 9th, 2002, 02:36 PM	#3
smittycft99 Board Regular Join Date: Apr 2002 Posts: 130	Thank you very much

May 9th, 2002, 03:24 PM	#4
Bert New Member Join Date: May 2002 Posts: 5	don't forget to put false in the end in your formula, otherwise you will get problems with sorting