LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tjb tjb is offline
external usenet poster
 
Posts: 14
Default modified vlookup help

I don't know if this will be a vlookup or something similar but here's what I
need:

-user enters a number that could range anywhere from 0 to 22667.27
-formula should match whatever number the user entered against an applicable
range and then return a different number
-For example a user enters 2931.15
-Formula should return a value of "125" since the user defined number falls
between 2930.92 and 2954.54
-Formula should return a value of "126" if user enters 2970.12 because that
value falls between 2954.55 and 2978.18

I have a list of hundreds of different ranges like this going from 0 all the
way to 22667.27.

Please help! Thanks.
 
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
Last Date Modified snickers22 Excel Worksheet Functions 2 June 16th 09 06:11 PM
Last Modified by... WJvanRooijen Excel Discussion (Misc queries) 4 September 1st 06 07:27 PM
Last Modified Steve Excel Worksheet Functions 1 July 20th 06 06:30 PM
Modified files Bob T Excel Discussion (Misc queries) 1 February 2nd 06 07:23 PM
Modified Duration Liz23 Excel Worksheet Functions 1 December 29th 05 09:10 PM


All times are GMT +1. The time now is 04:21 AM.

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"