|
04-19-2011, 03:46 PM | #2 |
Kind of a mod
Join Date: Aug 2005
Location: Donkey Land
Casino cash: $2006899
|
If you switch the columns, you could do it with a vlookup.
=VLOOKUP(1000000,A6:B37,2,true) would do it I think. |
Posts: 51,791
|
04-19-2011, 03:49 PM | #3 |
Kind of a mod
Join Date: Aug 2005
Location: Donkey Land
Casino cash: $2006899
|
Is this for personal use or for a class or something? If you're looking for a formula that would do it without switching the columns, I don't know one right off hand, but could probably figure it out.
|
Posts: 51,791
|
04-19-2011, 03:51 PM | #4 |
"Think BOOM!"
Join Date: Nov 2003
Location: 33.675° N 106.475° W
Casino cash: $10329900
VARSITY
|
It looks like you already figured it out in Row 42.
__________________
I think the young people enjoy it when I "get down," verbally, don't you? |
Posts: 180,739
|
04-19-2011, 03:52 PM | #5 |
**** SOC & **** YOU
Join Date: Jan 2006
Location: Chiefs Hell
Casino cash: $10018214
|
|
Posts: 19,884
|
04-19-2011, 03:53 PM | #6 |
**** SOC & **** YOU
Join Date: Jan 2006
Location: Chiefs Hell
Casino cash: $10018214
|
|
Posts: 19,884
|
04-19-2011, 03:56 PM | #7 |
**** SOC & **** YOU
Join Date: Jan 2006
Location: Chiefs Hell
Casino cash: $10018214
|
|
Posts: 19,884
|
04-19-2011, 03:56 PM | #8 |
Kind of a mod
Join Date: Aug 2005
Location: Donkey Land
Casino cash: $2006899
|
|
Posts: 51,791
|
04-19-2011, 03:59 PM | #9 |
"Think BOOM!"
Join Date: Nov 2003
Location: 33.675° N 106.475° W
Casino cash: $10329900
VARSITY
|
That's cheating.
__________________
I think the young people enjoy it when I "get down," verbally, don't you? |
Posts: 180,739
|
04-19-2011, 04:00 PM | #10 |
Kind of a mod
Join Date: Aug 2005
Location: Donkey Land
Casino cash: $2006899
|
=INDEX(A7:B37,MATCH(1000000,B7:B37),1)
That work? Last edited by DaFace; 04-19-2011 at 04:08 PM.. |
Posts: 51,791
|
04-19-2011, 04:05 PM | #11 |
**** SOC & **** YOU
Join Date: Jan 2006
Location: Chiefs Hell
Casino cash: $10018214
|
Nope, returned 30-jan
I havent been using the index feature in class but have briefly touched on vlookup so it is a safe bet to say the first thought was the right one. reading my textbook tho... use vlookup to search for exact matches or for the nearest value that is less than or equal to the search value. which is why it returns the 27th. its looking for the lowest value under 1m. |
Posts: 19,884
|
04-19-2011, 04:06 PM | #12 | |
Kind of a mod
Join Date: Aug 2005
Location: Donkey Land
Casino cash: $2006899
|
Quote:
|
|
Posts: 51,791
|
04-19-2011, 04:06 PM | #13 |
Most Valuable Villain
Join Date: Dec 2006
Casino cash: $3085047
|
The real question is.....how exactly ARE you getting a million dollars in 28 days?
|
Posts: 92,188
|
04-19-2011, 04:08 PM | #14 | |
**** SOC & **** YOU
Join Date: Jan 2006
Location: Chiefs Hell
Casino cash: $10018214
|
Quote:
=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! |
|
Posts: 19,884
|
04-19-2011, 04:11 PM | #15 |
Kind of a mod
Join Date: Aug 2005
Location: Donkey Land
Casino cash: $2006899
|
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.
|
Posts: 51,791
|
|
|