| . : News : . | . : Message of the Week : . |
You are currently viewing an archive of the Wilderness Guardians clan's IPB1 forums.
These forums were used by WG from 2008 to 2011, and now exist for historical and achival purposes only. For the clan's current forums, CLICK HERE. |
"You are a Wilderness Guardian. That northern wasteland; that land of blood, desolation and death is your dominion. Tonight we are going home." ~His Lordship |
|---|---|---|
| War Alert: OFF | Raid Alert: OFF | |
PM a WG Official |
||
Posted: February 16, 2009 10:04 pm  | |||
      IRC Nickname: Wayne|Eregion2 Group: Emeritus Posts: 3087 Member No.: 156 Joined: January 25, 2008 Total Events Attended: 8    | Nvm, both solved. // edit // In one cell I have a drop list of possible barrows items (27 of them, too many for an IF logical function). At the end of the row I need to calculate the total income from a barrows run, counting coins, runes, bolt racks, and name items. I need a function that will match the selected value in the drop list cell to the item in the next worksheet, and then display the CASH VALUE of that item which is in another cell. How can I do it? I think it might have something to do with the VLOOKUP function after looking at it but I'm not 100% sure (dashing off to class, cheerio). From Worksheet 1:  From Worksheet 2:  // edit //
Already taken care of. --------------------  | ||
Posted: February 16, 2009 10:20 pm | |||
| IRC Nickname: Mojohaza1 Group: Council Posts: 495 Member No.: 1574 Joined: December 22, 2008 Total Events Attended: 33 | lol? -------------------- | ||
Posted: February 16, 2009 10:28 pm | |||
| IRC Nickname: Wayne|Eregion2 Group: Emeritus Posts: 3087 Member No.: 156 Joined: January 25, 2008 Total Events Attended: 8 | It's just one of those things that you're messing with for half an hour and you can't figure out how to get it to work, so you ask for help and five seconds later you eureka.  // edit // Got another problem! -------------------- | ||
Posted: February 17, 2009 02:16 am | |||
| IRC Nickname: Wayne|Eregion2 Group: Emeritus Posts: 3087 Member No.: 156 Joined: January 25, 2008 Total Events Attended: 8 | Got the second problem figured out as well; cheers!  -------------------- | ||
Posted: February 17, 2009 04:00 am | |||
 IRC Nickname: Plano|Adam Group: Emeritus Posts: 1449 Member No.: 228 Joined: February 13, 2008 Total Events Attended: 107 | wow 10k nerd points to eregion, my hat's off to you.  --------------------  "If at first you don’t succeed, call it version 1.0" | ||
Posted: February 17, 2009 04:14 am | |||
| IRC Nickname: Wayne|Eregion2 Group: Emeritus Posts: 3087 Member No.: 156 Joined: January 25, 2008 Total Events Attended: 8 | When I finish the barrows loot sheet I'll share it. -------------------- | ||
Posted: February 17, 2009 04:17 am | |||
| IRC Nickname: Plano|Adam Group: Emeritus Posts: 1449 Member No.: 228 Joined: February 13, 2008 Total Events Attended: 107 | awesome! ive only been to barrows 3 times and on the third time my frist drop ever was guthans warspear lol. -------------------- "If at first you don’t succeed, call it version 1.0" | ||
Posted: February 17, 2009 04:50 am | |||
| IRC Nickname: Wayne|Eregion2 Group: Emeritus Posts: 3087 Member No.: 156 Joined: January 25, 2008 Total Events Attended: 8 | Nice! I got my first (and only) on the 99th trip.  Not sure how many I made before I started counting, lol. -------------------- | ||
Tricky Excel Problem