Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 09-05-2008, 03:31 PM
Novice
 
Join Date: Jun 2006
Location: Toronto Ontario Canada
Posts: 5
Grapejuice
Default Using the LOOKUP Command

I'm using =LOOKUP(999999,A13:A84) for finding the most recent entered Date in a list of dates. Is there a way to modify the line so that it will select the cell prior to the one the current code finds.



Eg: Curently the code spits out the contents of cell A72. I'd lile it to spit out the contents of cell A71.

Thanks in advance.
Reply With Quote
  #2  
Old 10-02-2008, 01:42 PM
Novice
 
Join Date: Jun 2006
Location: Toronto Ontario Canada
Posts: 5
Grapejuice
Default Hello? Anyone out there?!?!?

PLEASE HELP ME!!!!

I'm still waiting for someone to help me on this.
Reply With Quote
  #3  
Old 10-15-2008, 02:02 PM
Novice
 
Join Date: Jun 2006
Location: Toronto Ontario Canada
Posts: 5
Grapejuice
Exclamation Did I do something wrong?

Am I not using this forum corectly?
Is there no solution to my question?
I don't know where else to go for this.

PLEASE PLEASE SOMEONE OUT THERE HELP ME!! PLEASE!!!!!

I'm using =LOOKUP(999999,A13:A84) for finding the most recent entered Date in a list of dates.
In cell A100 is the =LOOKUP(999999,A13:A84) formula. This formula is giving me the contents of cell A72. I need a way to change the resulting cell to A71 instead of A72.

There MUST be a way to have Excel subtract the resulting cell by one.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Add-In:How to add command right click command bar phang Outlook 0 01-15-2007 02:53 AM
Help with Max or lookup fomula to return a name forAmaxValue dutch4fire23 Excel 0 07-28-2006 01:12 PM
command buttons ronf Excel 0 04-28-2006 08:32 AM
command buttons ronf Excel 0 12-03-2005 06:26 AM


All times are GMT -7. The time now is 12:08 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft