rrosenwald
New Member
- Joined
- Jul 7, 2012
- Messages
- 7
I'm running Excel 2007
I have three related questions here.
I have a concatenate: CONCATENATE(ADDRESS(MATCH(TODAY()-1,A:A,0)+1,3),":",ADDRESS(MATCH(TODAY(),A:A,0),6))
that yields a result like: $C$927:$F$1742
but: VLOOKUP(C1124,CONCATENATE(ADDRESS(MATCH(TODAY()-1,A:A,0)+1,3),":",ADDRESS(MATCH(TODAY(),A:A,0),6)),4,FALSE)
yields: #N/A
althhough: VLOOKUP(C1124,$C$927:$F$1742,4,FALSE)
yields the correct result.
Question 1: How do I use the CONCATENATE(ADDRESS(MATCH(TODAY()-1,A:A,0)+1,3),":",ADDRESS(MATCH(TODAY(),A:A,0),6)) inside a VLOOKUP?
Question 2: How would I do this within VBA?
Question 3: Would it be better to create a UDF Cell_Range() and how might that be written?
I have three related questions here.
I have a concatenate: CONCATENATE(ADDRESS(MATCH(TODAY()-1,A:A,0)+1,3),":",ADDRESS(MATCH(TODAY(),A:A,0),6))
that yields a result like: $C$927:$F$1742
but: VLOOKUP(C1124,CONCATENATE(ADDRESS(MATCH(TODAY()-1,A:A,0)+1,3),":",ADDRESS(MATCH(TODAY(),A:A,0),6)),4,FALSE)
yields: #N/A
althhough: VLOOKUP(C1124,$C$927:$F$1742,4,FALSE)
yields the correct result.
Question 1: How do I use the CONCATENATE(ADDRESS(MATCH(TODAY()-1,A:A,0)+1,3),":",ADDRESS(MATCH(TODAY(),A:A,0),6)) inside a VLOOKUP?
Question 2: How would I do this within VBA?
Question 3: Would it be better to create a UDF Cell_Range() and how might that be written?