Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.excel.programming > #110449
| From | dpb <none@none.net> |
|---|---|
| Newsgroups | microsoft.public.excel.programming |
| Subject | Enter value in compute cell location? |
| Date | 2018-01-16 16:26 -0600 |
| Organization | Aioe.org NNTP Server |
| Message-ID | <p3lu7i$btb$1@gioia.aioe.org> (permalink) |
Is it possible to have the result of an expression generate the address
into which to enter a value? Example would be given a State variable of
one of (say) three values, place another cell value in one of three
columns dependent upon the state. It's simple enough to duplicate a
lookup function in every cell of all three columns, but that seems
excessive.
GIVEN
A B C D E F
1 10 'A
2 5 'C
3 20 'A
4 2 'B
.
.
.
WANTED
A B C D E F
1 10 'A ? 10
2 5 'C ? 5
3 20 'A ? 20
4 2 'B ? 2
.
.
.
A formula in column C using B and a lookup can create D thru F (the "?")
would be...
--
Back to microsoft.public.excel.programming | Previous | Next — Next in thread | Find similar | Unroll thread
Enter value in compute cell location? dpb <none@none.net> - 2018-01-16 16:26 -0600
Re: Enter value in compute cell location? dpb <none@none.net> - 2018-01-18 13:56 -0600
Re: Enter value in compute cell location? "Jianguo Li" <2@1.com> - 2018-01-17 09:06 +0800
Re: Enter value in compute cell location? dpb <none@none.net> - 2018-01-22 08:39 -0600
Re: Enter value in compute cell location? dpb <none@none.net> - 2018-01-22 08:51 -0600
Re: Enter value in compute cell location? killme2008 <killme2008.14adfdf8@excelbanter.com> - 2018-01-24 08:11 +0000
Re: Enter value in compute cell location? Gerry Timber <swa2194@gmail.com> - 2018-01-24 03:34 -0800
Re: Enter value in compute cell location? dpb <none@none.net> - 2018-01-24 09:26 -0600
Re: Enter value in compute cell location? GS <gs@v.invalid> - 2018-01-24 10:37 -0500
Re: Enter value in compute cell location? GS <gs@v.invalid> - 2018-01-24 19:09 -0500
Re: Enter value in compute cell location? GS <gs@v.invalid> - 2018-01-24 19:12 -0500
Re: Enter value in compute cell location? Gerry Timber <swa2194@gmail.com> - 2018-01-24 12:07 -0800
Re: Enter value in compute cell location? GS <gs@v.invalid> - 2018-01-24 19:29 -0500
csiph-web