Re: Something other than Absolute, Relative or Mixed references
- From: veryeavy <veryeavy@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 5 Jan 2009 19:31:00 -0800
For the record my final fomula is this:
=IF(ISERROR(VLOOKUP(CONCATENATE(INDIRECT(ADDRESS(1,COLUMN())),$A2),JanPSGLData!$A:$J,10,0)),0,VLOOKUP(CONCATENATE(INDIRECT(ADDRESS(1,COLUMN())),$A2),JanPSGLData!$A:$J,10,0))
If this can in any way be "cleaned up" while still being able to be copied
downwards and sideways I will incorporate those enhancements.
Cheers All,
Matt
"Ron Rosenfeld" wrote:
On Mon, 5 Jan 2009 17:19:01 -0800, veryeavy.
<veryeavy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
The reason I want this is have a formula that can be copied down and across
that refers to the top cell in each column to which is copied.
Hopefully my header line makes it clear that playing around with "$" signs
is not the answer.
It makes it clear that you don't WANT to "play around with dollar signs" but
not clear why =A$1 wouldn't work.
--ron
- Follow-Ups:
- Re: Something other than Absolute, Relative or Mixed references
- From: Ron Rosenfeld
- Re: Something other than Absolute, Relative or Mixed references
- References:
- Something other than Absolute, Relative or Mixed references
- From: veryeavy
- Re: Something other than Absolute, Relative or Mixed references
- From: Ron Rosenfeld
- Something other than Absolute, Relative or Mixed references
- Prev by Date: How to format data in excel into a booklet, word or publisher?
- Next by Date: RE: I have a Table that I can't Sort--Final attempt for help
- Previous by thread: Re: Something other than Absolute, Relative or Mixed references
- Next by thread: Re: Something other than Absolute, Relative or Mixed references
- Index(es):
Relevant Pages
|
