 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / May 2008MATCH 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 In other words, I wish to use the A2:A21 as a range reference?? FLKulchar > In cell D2, I have the number 1. > [quoted text clipped - 14 lines] > > FLKulchar 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  SignatureGary''s Student - gsnu200789 > In cell D2, I have the number 1. > [quoted text clipped - 14 lines] > > FLKulchar Thank you... Now..It is PERFECT!! thanks for the help...my MATCH "pulldown" now works thanks to your help. FLKulchar > You are very close!! > [quoted text clipped - 23 lines] >> >> FLKulchar You are very welcome! Have a great weekend! SignatureGary''s Student - gsnu200789 > Thank you... > [quoted text clipped - 30 lines] > >> > >> FLKulchar |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.