 |
 | 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 / New Users / February 2007Simple(??) lookup question
I'm sure this is simple for lots of people, but I can't seem to get it. I have a date generated by a formula. I need to see if this date is in a list of dates. I tried MATCH, but I couldn't make it work. I looked at VLOOKUP in the Help file, but couldn't see how to make that work either. I need this in an IF formula in another cell. If anyone can line me out on this, I would greatly appreciate it. Ed If you use vlookup with the false parameter at the end, that should work. Regards, Eddie http://HelpExcel.com Are the dates in the list and the dates returned from the formulas *TRUE*, XL recognized dates? If yes, post your formulas with particulars on datalist configurations.  SignatureRegards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > I'm sure this is simple for lots of people, but I can't seem to get it. I > have a date generated by a formula. I need to see if this date is in a [quoted text clipped - 5 lines] > > Ed Hmm, MATCH should work. Let me demonstrate and see if this clears it up: date you have is in A1, list of dates is in column B, then =IF(MATCH(A1,B:B,FALSE),do_this_formula,otherwise_do_this_formula) Does that help? > I'm sure this is simple for lots of people, but I can't seem to get it. I > have a date generated by a formula. I need to see if this date is in a [quoted text clipped - 5 lines] > > Ed That got it! Thank you. Ed > Hmm, MATCH should work. Let me demonstrate and see if this clears it up: > date you have is in A1, list of dates is in column B, then [quoted text clipped - 10 lines] >> >> Ed |
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.