Results 1 to 4 of 4

Thread: Spreadsheet

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. June 03, 2009, 10:24 AM #1
    tone
    tone is offline
    tone's Avatar Just visiting
    Join Date
    May 2006
    Posts
    23,232
    Opifex TWC Milestone Award 2007 Modding Award Winner 2008 Modding Award Winner 2009 Modding Award Winner 2010 Modding Award Winner 2012 Modding Award Winner

    Default Spreadsheet

    Is anyone out there a spreadsheet guru?

    Is it possible to use the content of one cell as part of the address of another?

    So the answer in one cell is 5, can that become part of a reference to the the address of another cell (say you want to look at cell E5, can the answer from the first cell become part of the function to reference the other one?

    Hope that makes sense!


    Under patronage of Spirit of Rob; Patron of Century X, Pacco, Cherryfunk, Leif Erikson.
  2. June 03, 2009, 11:34 AM #2
    tone
    tone is offline
    tone's Avatar Just visiting
    Join Date
    May 2006
    Posts
    23,232
    Opifex TWC Milestone Award 2007 Modding Award Winner 2008 Modding Award Winner 2009 Modding Award Winner 2010 Modding Award Winner 2012 Modding Award Winner

    Default Re: Spreadsheet

    I think I have the answer, I can probably use the VLOOKUP function


    Under patronage of Spirit of Rob; Patron of Century X, Pacco, Cherryfunk, Leif Erikson.
  3. June 03, 2009, 11:48 AM #3
    King Nud
    King Nud is offline
    King Nud's Avatar Praepositus
    Join Date
    Oct 2008
    Location
    Newton Stewart, Scotland
    Posts
    5,698

    Default Re: Spreadsheet

    jeez tone, don't double post!

    on-topic: I don't really know how to help you there, my spreadsheet knowledge is not that good...
    Staff Writer at KingJamesGospel.com
  4. June 03, 2009, 11:55 AM #4
    tone
    tone is offline
    tone's Avatar Just visiting
    Join Date
    May 2006
    Posts
    23,232
    Opifex TWC Milestone Award 2007 Modding Award Winner 2008 Modding Award Winner 2009 Modding Award Winner 2010 Modding Award Winner 2012 Modding Award Winner

    Default Re: Spreadsheet

    No worries I think I'm sorted anyway thanks.


    Under patronage of Spirit of Rob; Patron of Century X, Pacco, Cherryfunk, Leif Erikson.
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules