+ Reply to Thread
Results 1 to 1 of 1

Matrix / multiple lookup / iteration challenge

  1. #1
    Registered User
    Join Date

    Matrix / multiple lookup / iteration challenge


    I have used this forum a few times to get help so let's hope you can do the business for me again!

    This is basically a problem of working with big lookup tables/matrixes

    The example has two sheets, "front" and "s4_1NS", in the future I'd like to have up to 50 sheets called s4_2NS, s5_1NS etc etc, but for the moment the problem is just for one site (I can replicate for the others later).

    Initially the challenge is this:
    On "front" you enter values in c4:c9 of offshore wave height, direction etc.
    I have set d4:d9 to lookup these values in the grid g3:m11 to return "a,b,c" etc. I then concanate these in cell a11 and lookup the concanated value on the worksheet "s4_1NS" to return nearshore wave height, period and direction.

    This seems to work when I lookup exactly the values that are in the matrix in "s4_1NS", but is there a way to lookup interpolated values, i.e. for an offshore wave height of 2metres and an offshore wave period of 5 secs...

    Can anyone offer advice, I have looked at XlXtrfun.xll as well - but I can't work out how this works....

    A bit more about the matrix in sheet S4_1NS
    Cells a1:l1 contain the labels
    cells a2:l2065 contain data ranges that need to be looked up
    I really need to try to lookup values that do not match exactly with the grid

    I hope this makes sense!

    Please let me know - I do not mind if the solution is by macro or just plain old formulas - I have ordered a VB book to try to learn this stuff for myself!


    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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