Results 1 to 5 of 5

Excel 2007 : Finding a value based on 2 inputs

Threaded View

  1. #1
    Registered User
    Join Date
    08-10-2011
    Location
    NYC
    MS-Off Ver
    Excel 2007
    Posts
    3

    Finding a value based on 2 inputs

    I have the below s/s

    From (USD Size) To (USD Size) Security Fee (USD)
    - 33 A 1
    33 163 A 2
    163 978 A 3
    - 163 B 3
    163 489 B 10
    489 815 B 20

    I need to return the Fee (USD) based on the Security and the range From/To. So if i have security A and size = 153 i should get 2 as the result.

    Can someone help?
    Thanks
    Max
    Last edited by maxcavalli; 08-10-2011 at 12:49 PM.

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