Formula needed: argument changes as more data is added
OOPs
wrong thread
"Mike H" wrote:
Hi,
Well we can only guess what result you expect from 'and so on' but there are
6 combinations of yes/no/na and one way is to put them in a 2 column table
like this and I used column L and M. Column L are the combinations and M are
what you want to return.
Col L Col M
yesyes aa
yesno bb
yesNA cc
nono dd
nona ee
nana ff
You can then use vlookup
=VLOOKUP(A2&B2,L1:M6,2,FALSE)
Mike
"BK" wrote:
The math is simply the difference between the values in two cells, but one of
the cells will change each time the table is updated.
For example, Row 1 headers are Apr, Mar, Feb, Jan, etc. and the last column
is Prior Year. In At any given time, I want the value for the most recent
month minus the prior year. How do I get it to automatically pick up the
last non-blank cell in the row?
Thanks
|