Quote:
Originally Posted by pr_capone
you know what I did? I modified your first post to
=VLOOKUP(1500000,A6:B37,2,true)
which returned the correct answer. for the purposes of this specific assignment, that will do just fine.
thx for the assist Face!
|
Cool. In case anyone cares, I just tried my second one as well, and it seems to work fine too. INDEX and MATCH are pretty powerful, but they're a bit of a pain in the ass.