Need help with creating a formula

jennsmom

New Member
Joined
Sep 22, 2006
Messages
2
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

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,209
Have a look at the VLOOKUP function in Excel's Help...

=VLOOKUP(Number,ExplanationTable,2,0)
 

jennsmom

New Member
Joined
Sep 22, 2006
Messages
2
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

Legend
Joined
Jun 19, 2002
Messages
63,650
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

Active Member
Joined
Dec 4, 2002
Messages
323
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

Well-known Member
Joined
Sep 4, 2002
Messages
1,556
Platform
  1. MacOS
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
 

Forum statistics

Threads
1,136,705
Messages
5,677,300
Members
419,684
Latest member
BOB101

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top