Help With formulating a cell

  • 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. The dollar amounts can be changed just by, uh... , changing them, but the number and name in the columns next to them must saty 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!! (e-mail address removed)
 
One way:

Use VLOOKUP. Assume your sequential numbers are in column A, the names
in column B and the amounts in column C. Also assume the cell you enter
the lookup sequential number in is D1. Then:

to return the name:

=VLOOKUP(D1, A:C, 2, FALSE)

to return the amount:

=VLOOKUP(D1, A:C, 3, FALSE)
 
Assuming your sequential numbers are in column A , names in B and Dollar
amounts in C, then in D1 you can type the sequential number you want to look
up and in E1 put =VLOOKUP(D1,a:c,2,false) and in F1 put
=VLOOKUP(D1,a:c,3,false)

This should give you the corresponding name in E1 and dollar amount in E1
for whatever sequential number you type in D1 (assuming it's somewhere in
column A)

Then you could just copy-down the formulas from E1 and F1 as far as you want
and then just sum column E for a dollar total.........

hth
Vaya con Dios,
Chuck, CABGx3


PeterJ said:
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. The dollar amounts can
be changed just by, uh... , changing them, but the number and name in the
columns next to them must saty 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!! (e-mail address removed)
 
Back
Top