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.

The formula would be something like this:

=INDEX($IX$19:$JC$38, MATCH($F18, $IW$19:$IW$38, 0), MATCH($E18, $IX$18:$JC$18, 0))


Red - table of values to return answer from
Green - match the correct row in the table
Blue - match the correct column in the table

Posting a sample workbook would be much more effective than a screenshot. How does column D fit in?

Sample Worksheet coming Up..

As requested, should make sense when you see it.

http://www.fileserve.com/file/WPVVHDD

Originally Posted by mardon

Work has finished now so i'll play around with it tomorrow and report back.

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

I'll have a play this morning and see how I get on. There may be further IF statements to add if it works.

Help so far is most appriciated.

Regards

EDIT-- It returns the value "True" not a number from the table. Any ideas?

The formula given can't return TRUE.

Post up your sample workbook with the data table. I only have Excel 2003, so if you would move that table to the left about 20 columns so it doesn't go past the last column IV, I would appreciate it.

Then make sure your version of the formula is there, too, so I can see what's giving you a TRUE result.

You put the formula into S18 twice. When you put the exact same formula into a cell twice, the equal sign on the second copy creates a permanent TRUE test, like = cat = cat.

Take out the second copy of the formula and the result of 1.47 should appear.