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...

Some of the values in I52:I77 contain spaces, e.g. 1 300. If these are meant to be numbers then do an edit replace and replace space with nothing then your formula should work.

At the moment the LOOKUP returns 1 300 which is a text string not a number. When you try to multiply this by a number you get an error

Originally Posted by oldchippy

Hi,

The errors are caused by your numbers in your Iron table, you need to remove the spaces, Excel is reading these as text and not numbers.

Gah, I thought I fixed that, thanks