RE: Table Lookup

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Sorry, but my "Cystal Ball" didn't come back from the cleaner, yet, therefor
I can't refer to information one holds "close to his chest" - however, may I
suggest that you try again as this works 123%:
http://img64.imageshack.us/img64/346/nonamer.png
Micky


"Alister Gough" wrote:

Hi guys,

Thanks for the help, unfortunately they didn't work. They both come up with
the error message #VALUE!

I think may have left out some important things I forgot to mention.

1st the value I am looking up is on a different sheet.
2nd the value being looked up is part of a drop down menu so that everyone
enters the data the same. The hours are worked out as part of a formula.
.

Relevant Pages

  • Re: Look at all that closet space!
    ... Words to the wise, Samurai wrote: ... >> Just shave it completely, same with chest hear. ... >> problems, feels cleaner as well. ...
    (rec.games.computer.ultima.dragons)
  • Re: Look at all that closet space!
    ... > Just shave it completely, same with chest hear. ... > problems, feels cleaner as well. ... You don't remember SP's story about the ingrowing hair, ...
    (rec.games.computer.ultima.dragons)