Need help with creating a formula

jennsmom

New Member
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.

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
Have a look at the VLOOKUP function in Excel's Help...

=VLOOKUP(Number,ExplanationTable,2,0)

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.

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.

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.

Hi:

Maybe something like this might help.
Book1
ABCDE
1numberdescription
215305Tab Rule
315306Item 1
415077Item 2
514100Item 3
6
7
8
9
10
11Ewxplaination Table
12numberdescription
1315305Tab Rule
1415306Item 1
1515077Item 2
1614100Item 3
17
Sheet2

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

plettieri

Replies
8
Views
172
Replies
9
Views
262
Replies
1
Views
397
Replies
4
Views
313
Replies
1
Views
127

1,219,914
Messages
6,150,936
Members
450,994
Latest member
MacOrch

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back