Results 1 to 9 of 9

use of Vlookup for a range of values

Threaded View

  1. #1
    Registered User
    Join Date
    11-23-2011
    Location
    Mumbai India
    MS-Off Ver
    Excel 2003
    Posts
    5

    use of Vlookup for a range of values

    Hello friends..
    I have an excel sheet which helps to calculate pip e thickness and shcedule. The schedule is selected based on thickness calculated for eg. On “refdt” sheet, when the pipe thknss is calculated as something in between 0.065 to 0.109, the schedule should be selected as “40”. For some value which is <= 0.147 but greater than 0.109 , the schedule selected should be “80”
    The nested If function do not work for this as too many conditions are involved. How do we apply Vlookup to this data for searching in a range? Please advise.(sheet attached)

    Thanks
    Maoj
    Attached Files Attached Files
    Last edited by amanojp; 11-28-2011 at 02:04 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1