Need help with a formula that a second grader could probably do!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hey everyone. I have a really dumb question but I am just not good at this Excel thing. Haha. I am trying to create a spreadsheet that will allow me to have a column of sequential numbers next to a column of names which in turn is next to column of dollar amounts. These columns are 10 rows deep (?) and are within the spreadsheet whereas the related information is in cell A1:c10 with completely different information beginning in cells A11. None of the cells are linked at the moment because I am an amateur. The dollar amounts can be changed just by, uh... , changing them, but the number and name in the columns next to them must stay the same. Okay, so far? Okay-here's my problem: How do I create a cell that will allow me to enter one of the sequential numbers and have either the name and dollar amount next to that typed-in number show up when I hit "enter"(still allowing me to have the sum of a series of similar cells added in yet ANOTHER cell) or simply have the dollar amount show. I suppose i need to know how to write "If I type in the number 4, I want the word dummy to appear." Any help would be GREATLY appreciated!! (I DO have EXCEL books at work that would help me with this, but I am home sick and desperately need to get this done!) (e-mail address removed)
 
First of all, I have to tell you that this is a group for MS-Access (The
database), so you will probably get yelled at!

Im not completly sure that I understand your question, but have a look at
this:

You may get some better answers if you post your question in a dedicated
Excel NG.

Having said that, it sounds to me like a job for the VLOOKUP command:

A B
1 Code Name
2 1 Dummy
3 2 Fred
4 3 Bill


In a cell: =VLOOKUP(<your code to lookup>,A2:B4,2,false)

VLOOKUP(<cell to lookup>, <Range to lookup in>, <column in that range to
return>, <find closest value?>)

So else where on your sheet:


H I J
25
26 3 =VLOOKUP(H26,A2:B4,2,false)
27

should return you 'Fred' in cell I26

Hey everyone. I have a really dumb question but I am just not good at
Click to expand...
this Excel thing. Haha. I am trying to create a spreadsheet that will
allow me to have a column of sequential numbers next to a column of names
which in turn is next to column of dollar amounts. These columns are 10
rows deep (?) and are within the spreadsheet whereas the related information
is in cell A1:c10 with completely different information beginning in cells
A11. None of the cells are linked at the moment because I am an amateur.
The dollar amounts can be changed just by, uh... , changing them, but the
number and name in the columns next to them must stay the same. Okay, so
far? Okay-here's my problem: How do I create a cell that will allow me to
enter one of the sequential numbers and have either the name and dollar
amount next to that typed-in number show up when I hit "enter"(still
allowing me to have the sum of a series of similar cells added in yet
ANOTHER cell) or simply have the dollar amount show. I suppose i need to
know how to write "If I type in the number 4, I want the word dummy to
appear." Any help would be GREATLY appreciated!! (I DO have EXCEL books
at work that would help me with this, but I am home sick and desperately
need to get this done!) (e-mail address removed)
 
Hi PM
I would agree with Chris on the vlookup comand.
Maybe have a couple of spare rows at the top where you can type a #, say 4 &
in the column next to 4 the word dummy will appear.....the only dummy is the
person that does not ask the questionssss. Hope this help even though you
are in the incorrect newsgroup..

All the best
Craig



Hey everyone. I have a really dumb question but I am just not good at
Click to expand...
this Excel thing. Haha. I am trying to create a spreadsheet that will
allow me to have a column of sequential numbers next to a column of names
which in turn is next to column of dollar amounts. These columns are 10
rows deep (?) and are within the spreadsheet whereas the related information
is in cell A1:c10 with completely different information beginning in cells
A11. None of the cells are linked at the moment because I am an amateur.
The dollar amounts can be changed just by, uh... , changing them, but the
number and name in the columns next to them must stay the same. Okay, so
far? Okay-here's my problem: How do I create a cell that will allow me to
enter one of the sequential numbers and have either the name and dollar
amount next to that typed-in number show up when I hit "enter"(still
allowing me to have the sum of a series of similar cells added in yet
ANOTHER cell) or simply have the dollar amount show. I suppose i need to
know how to write "If I type in the number 4, I want the word dummy to
appear." Any help would be GREATLY appreciated!! (I DO have EXCEL books
at work that would help me with this, but I am home sick and desperately
need to get this done!) (e-mail address removed)
 
Back
Top