| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MATCH function...AGAIN
In cell D2, I have the number 1.
The following concatenation ="A"&(D2+1)&":A21" works out to be...A2:A21 WHY CAN I NOT USE THIS AS MY REFERENCE LOOK-UP IN THE MATCH FUNCTION?? IN OTHER WORDS, =MATCH($C$2,"A"&(D2+1)&":A21",0) does NOT work? Please help? Thanks, FLKulchar |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MATCH function...AGAIN
In other words, I wish to use the A2:A21 as a range reference??
FLKulchar "F. Lawrence Kulchar" wrote: In cell D2, I have the number 1. The following concatenation ="A"&(D2+1)&":A21" works out to be...A2:A21 WHY CAN I NOT USE THIS AS MY REFERENCE LOOK-UP IN THE MATCH FUNCTION?? IN OTHER WORDS, =MATCH($C$2,"A"&(D2+1)&":A21",0) does NOT work? Please help? Thanks, FLKulchar |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MATCH function...AGAIN
You are very close!!
=MATCH($C$2,INDIRECT("A"&(D2+1)&":A21"),0) whenever you are using a formula that displays a string like Z2:Z34 you need to use INDIRECT() because MATCH() wants a true range and not just a string -- Gary''s Student - gsnu200789 "F. Lawrence Kulchar" wrote: In cell D2, I have the number 1. The following concatenation ="A"&(D2+1)&":A21" works out to be...A2:A21 WHY CAN I NOT USE THIS AS MY REFERENCE LOOK-UP IN THE MATCH FUNCTION?? IN OTHER WORDS, =MATCH($C$2,"A"&(D2+1)&":A21",0) does NOT work? Please help? Thanks, FLKulchar |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MATCH function...AGAIN
Thank you...
Now..It is PERFECT!! thanks for the help...my MATCH "pulldown" now works thanks to your help. FLKulchar "Gary''s Student" wrote in message ... You are very close!! =MATCH($C$2,INDIRECT("A"&(D2+1)&":A21"),0) whenever you are using a formula that displays a string like Z2:Z34 you need to use INDIRECT() because MATCH() wants a true range and not just a string -- Gary''s Student - gsnu200789 "F. Lawrence Kulchar" wrote: In cell D2, I have the number 1. The following concatenation ="A"&(D2+1)&":A21" works out to be...A2:A21 WHY CAN I NOT USE THIS AS MY REFERENCE LOOK-UP IN THE MATCH FUNCTION?? IN OTHER WORDS, =MATCH($C$2,"A"&(D2+1)&":A21",0) does NOT work? Please help? Thanks, FLKulchar |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MATCH function...AGAIN
You are very welcome! Have a great weekend!
-- Gary''s Student - gsnu200789 "FLKulchar" wrote: Thank you... Now..It is PERFECT!! thanks for the help...my MATCH "pulldown" now works thanks to your help. FLKulchar "Gary''s Student" wrote in message ... You are very close!! =MATCH($C$2,INDIRECT("A"&(D2+1)&":A21"),0) whenever you are using a formula that displays a string like Z2:Z34 you need to use INDIRECT() because MATCH() wants a true range and not just a string -- Gary''s Student - gsnu200789 "F. Lawrence Kulchar" wrote: In cell D2, I have the number 1. The following concatenation ="A"&(D2+1)&":A21" works out to be...A2:A21 WHY CAN I NOT USE THIS AS MY REFERENCE LOOK-UP IN THE MATCH FUNCTION?? IN OTHER WORDS, =MATCH($C$2,"A"&(D2+1)&":A21",0) does NOT work? Please help? Thanks, FLKulchar |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can we get unique values in match function for same match key. | Excel Worksheet Functions | |||
| index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
| Match as well as does not match array function | Excel Discussion (Misc queries) | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Linear Mode
