software

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.

quot;Kylie Rosequot; wrote:
gt; .. I need to make 1 = $50 and 2 = $100 and 3 = $120 etc
gt; I need to do this by entering 1, 2 or 3 in column A and the value
gt; 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=quot;quot;,quot;quot;,IF(ISNA(MATCH(A1,{1;2;3},0)),quot;No matchquot;,
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
savefile.com/projects/236895
xdemechanik
---
Hi!

gt; I need to make 1 = $50 and 2 = $100 and 3 = $120 etc
gt; I need to do this by entering 1, 2 or 3 in column A and the value
gt; automatically appearing in column D, is this possible?

=LOOKUP(A1,{0,quot;quot;;1,50;2,100;3,120})

gt; Also I would like to hide a column and only show cells from that column in
gt; the row that I apply value to in another cell of the same row. Essentially
gt; hiding the whole column and only showing value in a row when the row is in
gt; use.

You can do that using conditional formatting but you'd need to provide more
specific details.

Biff

quot;Kylie Rosequot; gt; wrote in message
...
gt; Please help me....
gt; Example:
gt; I need to make 1 = $50 and 2 = $100 and 3 = $120 etc
gt; I need to do this by entering 1, 2 or 3 in column A and the value
gt; automatically appearing in column D, is this possible?
gt;
gt; Also I would like to hide a column and only show cells from that column in
gt; the row that I apply value to in another cell of the same row. Essentially
gt; hiding the whole column and only showing value in a row when the row is in
gt; use.
gt;
gt; Please help me, I want to create something for a job interview and can't
gt; work it out!
gt;
gt; Thank you so much whoever can answer this.
gt; =LOOKUP(A1,{0,quot;quot;;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
savefile.com/projects/236895
xdemechanik
---
Thank you very much!!!!!
You're excellent!
Cheers
Kylie

quot;Biffquot; wrote:

gt; Hi!
gt;
gt; gt; I need to make 1 = $50 and 2 = $100 and 3 = $120 etc
gt; gt; I need to do this by entering 1, 2 or 3 in column A and the value
gt; gt; automatically appearing in column D, is this possible?
gt;
gt; =LOOKUP(A1,{0,quot;quot;;1,50;2,100;3,120})
gt;
gt; gt; Also I would like to hide a column and only show cells from that column in
gt; gt; the row that I apply value to in another cell of the same row. Essentially
gt; gt; hiding the whole column and only showing value in a row when the row is in
gt; gt; use.
gt;
gt; You can do that using conditional formatting but you'd need to provide more
gt; specific details.
gt;
gt; Biff
gt;
gt; quot;Kylie Rosequot; gt; wrote in message
gt; ...
gt; gt; Please help me....
gt; gt; Example:
gt; gt; I need to make 1 = $50 and 2 = $100 and 3 = $120 etc
gt; gt; I need to do this by entering 1, 2 or 3 in column A and the value
gt; gt; automatically appearing in column D, is this possible?
gt; gt;
gt; gt; Also I would like to hide a column and only show cells from that column in
gt; gt; the row that I apply value to in another cell of the same row. Essentially
gt; gt; hiding the whole column and only showing value in a row when the row is in
gt; gt; use.
gt; gt;
gt; gt; Please help me, I want to create something for a job interview and can't
gt; gt; work it out!
gt; gt;
gt; gt; Thank you so much whoever can answer this.
gt;
gt;
gt;

Thank you heaps!!
Help much appreciated!
Cheers
Kylie

quot;Maxquot; wrote:

gt; quot;Kylie Rosequot; wrote:
gt; gt; .. I need to make 1 = $50 and 2 = $100 and 3 = $120 etc
gt; gt; I need to do this by entering 1, 2 or 3 in column A and the value
gt; gt; automatically appearing in column D, is this possible?
gt;
gt; If the lookup list (1 = $50, 2 = $100, etc) isn't too long
gt;
gt; Try in D1:
gt; =IF(A1=quot;quot;,quot;quot;,IF(ISNA(MATCH(A1,{1;2;3},0)),quot;No matchquot;,
gt; VLOOKUP(A1,{1,50;2,100;3,120},2,0)))
gt; Copy D1 down as far as required
gt;
gt; (I don't have a suggestion for your 2nd Q, sorry)
gt; --
gt; Max
gt; Singapore
gt; savefile.com/projects/236895
gt; xdemechanik
gt; ---
gt;
gt;
gt;

gt;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

quot;Maxquot; gt; wrote in message
...
gt;gt; =LOOKUP(A1,{0,quot;quot;;1,50;2,100;3,120})
gt;
gt; If col A contains numbers higher than 3, I'm not sure if
gt; the result returned: 120 would be a mite misleading here ?
gt; --
gt; Max
gt; Singapore
gt; savefile.com/projects/236895
gt; xdemechanik
gt; ---
gt;
gt;
quot;Biffquot; wrote:
gt; gt;I need to do this by entering 1, 2 or 3 in column A
gt;
gt; I don't see anything that mentions values higher than 3.

Agreed. But I was hinting at the possibility
of a quot;wrongquot; input of a number higher than
what is mentioned in the OP
(the built-in quot;error trapquot; part of it)

Anyway, the OP seems happy with both options lt;ggt;
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
You're welcome !
Thanks for the feedback ..
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;Kylie Rosequot; gt; wrote in message
...
gt; Thank you heaps!!
gt; Help much appreciated!
gt; Cheers
gt; Kylie