Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
change value in a cell according to another cells value
Please help me....
Example: I need to make 1 = $50 and 2 = $100 and 3 = $120 etc I need to do this by entering 1, 2 or 3 in column A and the value automatically appearing in column D, is this possible? Also I would like to hide a column and only show cells from that column in the row that I apply value to in another cell of the same row. Essentially hiding the whole column and only showing value in a row when the row is in use. Please help me, I want to create something for a job interview and can't work it out! Thank you so much whoever can answer this. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
change value in a cell according to another cells value
"Kylie Rose" wrote:
.. I need to make 1 = $50 and 2 = $100 and 3 = $120 etc I need to do this by entering 1, 2 or 3 in column A and the value automatically appearing in column D, is this possible? If the lookup list (1 = $50, 2 = $100, etc) isn't too long Try in D1: =IF(A1="","",IF(ISNA(MATCH(A1,{1;2;3},0)),"No match", VLOOKUP(A1,{1,50;2,100;3,120},2,0))) Copy D1 down as far as required (I don't have a suggestion for your 2nd Q, sorry) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
change value in a cell according to another cells value
Hi!
I need to make 1 = $50 and 2 = $100 and 3 = $120 etc I need to do this by entering 1, 2 or 3 in column A and the value automatically appearing in column D, is this possible? =LOOKUP(A1,{0,"";1,50;2,100;3,120}) Also I would like to hide a column and only show cells from that column in the row that I apply value to in another cell of the same row. Essentially hiding the whole column and only showing value in a row when the row is in use. You can do that using conditional formatting but you'd need to provide more specific details. Biff "Kylie Rose" wrote in message ... Please help me.... Example: I need to make 1 = $50 and 2 = $100 and 3 = $120 etc I need to do this by entering 1, 2 or 3 in column A and the value automatically appearing in column D, is this possible? Also I would like to hide a column and only show cells from that column in the row that I apply value to in another cell of the same row. Essentially hiding the whole column and only showing value in a row when the row is in use. Please help me, I want to create something for a job interview and can't work it out! Thank you so much whoever can answer this. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
change value in a cell according to another cells value
=LOOKUP(A1,{0,"";1,50;2,100;3,120})
If col A contains numbers higher than 3, I'm not sure if the result returned: 120 would be a mite misleading here ? -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
change value in a cell according to another cells value
Thank you very much!!!!!
You're excellent! Cheers Kylie "Biff" wrote: Hi! I need to make 1 = $50 and 2 = $100 and 3 = $120 etc I need to do this by entering 1, 2 or 3 in column A and the value automatically appearing in column D, is this possible? =LOOKUP(A1,{0,"";1,50;2,100;3,120}) Also I would like to hide a column and only show cells from that column in the row that I apply value to in another cell of the same row. Essentially hiding the whole column and only showing value in a row when the row is in use. You can do that using conditional formatting but you'd need to provide more specific details. Biff "Kylie Rose" wrote in message ... Please help me.... Example: I need to make 1 = $50 and 2 = $100 and 3 = $120 etc I need to do this by entering 1, 2 or 3 in column A and the value automatically appearing in column D, is this possible? Also I would like to hide a column and only show cells from that column in the row that I apply value to in another cell of the same row. Essentially hiding the whole column and only showing value in a row when the row is in use. Please help me, I want to create something for a job interview and can't work it out! Thank you so much whoever can answer this. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
change value in a cell according to another cells value
Thank you heaps!!
Help much appreciated! Cheers Kylie "Max" wrote: "Kylie Rose" wrote: .. I need to make 1 = $50 and 2 = $100 and 3 = $120 etc I need to do this by entering 1, 2 or 3 in column A and the value automatically appearing in column D, is this possible? If the lookup list (1 = $50, 2 = $100, etc) isn't too long Try in D1: =IF(A1="","",IF(ISNA(MATCH(A1,{1;2;3},0)),"No match", VLOOKUP(A1,{1,50;2,100;3,120},2,0))) Copy D1 down as far as required (I don't have a suggestion for your 2nd Q, sorry) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
change value in a cell according to another cells value
I need to do this by entering 1, 2 or 3 in column A
I don't see anything that mentions values higher than 3. Biff "Max" wrote in message ... =LOOKUP(A1,{0,"";1,50;2,100;3,120}) If col A contains numbers higher than 3, I'm not sure if the result returned: 120 would be a mite misleading here ? -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
change value in a cell according to another cells value
"Biff" wrote:
I need to do this by entering 1, 2 or 3 in column A I don't see anything that mentions values higher than 3. Agreed. But I was hinting at the possibility of a "wrong" input of a number higher than what is mentioned in the OP (the built-in "error trap" part of it) Anyway, the OP seems happy with both options <g -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
change value in a cell according to another cells value
You're welcome !
Thanks for the feedback .. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Kylie Rose" wrote in message ... Thank you heaps!! Help much appreciated! Cheers Kylie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying functions from one cell to other cells | New Users to Excel | |||
conditional cell shading when a change occurs | Excel Discussion (Misc queries) | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
How do I link many cells to one particular cell? | Excel Discussion (Misc queries) | |||
How do I link many cells to one particular cell? | Excel Discussion (Misc queries) |