Results 1 to 5 of 5

Lookup (Unknown errors?)

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-11-2007
    Posts
    263

    Lookup (Unknown errors?)

    Ok, I have gotten a little further with the spreadsheet I'm working on. (working 2 jobs really don't give for a lot of time to spend on it)

    Here is the issue:

    In the attached file I'm attempting to create a Building Cost Estimate list, it takes the level, then looks it up, and spits it back out, and after it does that it multiples it by the amount you require:

    =LOOKUP(B27,'Cost Expendatures'!H4:I24)*G27

    This is for wood, looking at how much wood it would take at a given level. This I have no problem with.

    The problem is when I actually attempt it at another field such as the Iron, using the same calculation with the $ signs in it so to keep some of the math the same:

    =LOOKUP($B$29,'Cost Expendatures'!$H$52:I77)*$G$29

    This for some reason doesn't work.... It should, but it doesn't...any help would be appreciated on figuring out why...
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1