Results 1 to 11 of 11

VLookup/HLookup or Both.. Even Possible?

Threaded View

  1. #1
    Registered User
    Join Date
    05-17-2011
    Location
    Manchester
    MS-Off Ver
    Excel 2007
    Posts
    6

    VLookup/HLookup or Both.. Even Possible?

    I am trying to create a spreadsheet which will auto input information depending on a Fuse Type, British Standard Rating, and Fuse Rating Rating(A).
    E.g.
    BS Rating = 60898
    Fuse Type = 1,2,B, (3+C) & 4
    Rating = various numbers.

    This will then return the Maximum Permitted Disconnection Time from the table you will see in the screen shot.

    I've attached a screen printto better illustrate my problem.

    Does it make sense? I'll try and explain further if not. I've been scratching my head all morning!

    Thanks very very much for any help you can offer.

    Regards

    \1

    EDIT:

    Thought i'd expand my issue a little further.

    Basicly for the first line I would like Cell S18 to look at E18 and F18. In this case the Values will be C(E18) and 3(F18) and will then look them up on the Range boxing in Red (I'll call it 60808). In this case the result will be N/A.
    Last edited by mardon; 05-18-2011 at 11:53 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