Need help with creating a formula

[jennsmom]

I have an Excel Spreadsheet that lists numbers in one column (A) and in column (D) the explanation of what that number means is listed. Such as if I type 15305 into Column A I want the word Tab Rule to appear in Column D. What would be the formula. Thank you.

 

[Aladin Akyurek]

Have a look at the VLOOKUP function in Excel's Help...

=VLOOKUP(Number,ExplanationTable,2,0)

 

[jennsmom]

Looked at VLookup. Don't understand how to do it. It seems I have to put in the Formula each time I want to get an answer. I want ot set it p so everytime I put a number into column A the corresponding text appears in Column D. Unless I am doing the Lookup function wrong.

 

[VoG]

Assuming that your data is in A2:D100 and you want to lookup a value in A1 then in D1 enter the formula

=VLOOKUP(A1, A2:D100, 4, FALSE)

When you enter a new number in A1 D1 should update.

 

[gaynard_nelson]

Looked at VLookup. Don't understand how to do it. It seems I have to put in the Formula each time I want to get an answer. I want ot set it p so everytime I put a number into column A the corresponding text appears in Column D. Unless I am doing the Lookup function wrong.

For number you can use the address where the number you want locate on the VLOOKUP table. You can copy it down and the formula will automatically adjust for for each new value in column A.

=VLOOKUP(Number,ExplanationTable,2,0)

Put this formula in Col D.
=VLOOKUP(A1,ExplanationTable,2,0)
=VLOOKUP(A2,ExplanationTable,2,0)

etc.

 

[plettieri]

Hi:

Maybe something like this might help.

Book1
	A	B	C	D	E
1	number			description
2	15305			Tab Rule
3	15306			Item 1
4	15077			Item 2
5	14100			Item 3
6
7
8
9
10
11	Ewxplaination Table
12	number	description
13	15305	Tab Rule
14	15306	Item 1
15	15077	Item 2
16	14100	Item 3
17
Sheet2

Edit: The formual copied down shoud read: =VLOOKUP(A2,$A$12:$B$16,2,0)

plettieri