Apple Event: May 7th at 7 am PT

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Lookup in Range?

Hiya folks.


Just wondering if I can use a LOOKUP for a value in a range. Example:


Lookup value: 2300


Range table:



Minimum
Maximum Associate
1 999 alpha
1000 2499 bravo
2500 4999 charlie
5000 9999 delta
10000 19999 echo
20000 99999 foxtrot


How can I look up the value 2300 and return its associate?


Cheers

Mac Pro, OS X Mountain Lion (10.8.2), Hypercard UG!

Posted on Nov 4, 2012 12:12 PM

Reply
Question marked as Best reply

Posted on Nov 4, 2012 1:51 PM

Bio,


This may work for you:


User uploaded file


In the table on the right:


A1 is the value to lookup in the table on the left.


B1=VLOOKUP(A1, Table 4 :: A:C, 3)


The table on the left is named "Table 4"

17 replies

Nov 6, 2012 7:23 AM in response to Badunit

You are correct. In this instance, some would argue that the current "tag" doesn't go far enough. So they would replace the functionality of the tag instead of providing additional tags for further povision. The problem here is that the documentation is slim enough that you might miss some endearing features if you do indeed rewrite such a function. So, my solution is to just add another tag to provide the functionality that I need, and keep my own docs on my own tags. That way, encapsulation is more reliable as I'm not trying to jam a feature set into a single tag. Yes, the tag count grows, but it's documented well. Documentation has always been a problem for languages. It's one of the reasons I'm migrating languages now. Development resources are a major part of finding out how to get around obstacles.


There is no iterate or routine for this type of programming. It's more FileMaker style. I was thinking range, and that's what I searched for, and nothing came up. I think in terms of iteration than qualifying a test cell. That to me feels like a workaround that we had to do in FileMaker for so long. It feels super dirty.

Lookup in Range?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.