LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 9
Default Check value against multiple ranges

I have a date and want to know in what period this is.

Reference ranges:
period begin end
jan 1/1/2008 14/1/2008
feb 15/1/2008 14/2/2008
mrt 15/2/2008 14/3/2008
apr 15/3/2008 14/4/2008

test value: result:
12/3/2008 mrt
1/4/2008 apr

I can do this with an nested IF function, but then I´m limited to 6 nested
IF statements. And I need more, in this case 7 or 8.

Is there some case statement like worksheet function ?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple IF statements looking up multiple ranges. mike Excel Worksheet Functions 7 August 9th 07 04:55 PM
Can I create Multiple passwords to edit multiple ranges? Conker10382 Excel Discussion (Misc queries) 8 December 31st 06 07:58 PM
How do i update multiple data ranges across multiple worksheets? mwah Excel Discussion (Misc queries) 0 July 6th 06 04:57 AM
Multiple Consolidation Ranges Matt Cromer Excel Discussion (Misc queries) 0 December 1st 05 09:51 PM
Multiple Consolidation Ranges nc Excel Discussion (Misc queries) 2 April 26th 05 10:24 AM


All times are GMT +1. The time now is 06:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"