Help with a formula a second grader could probably write!

P

pmjones2

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!) [email protected]
 
A

Andy B

Hi

Have a look at the VLOOKUP() function. This will look down a column of
information to find a specified value, and then return the value from an
adjacent cell.

Andy.

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!) [email protected]
 
B

Bob Phillips

D1: sequential number
E1: =VLOOKUP(D1,$A$1:$C$10,2,FALSE)
F1: =VLOOKUP(D1,$A$1:$C$10,3,FALSE)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

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!) [email protected]
 
Top