Hallo Brian,
Op zaterdag 06 juni 2009 schreef Brian Barker aan Hans Beekhuizen:
BB> I'm not sure why you need a database here: perhaps you don't.
BB> If the database is to contain only a table of names and
BB> ingredients, a spreadsheet would serve just as well.
I was thinking about a database, because I might want to make
more than one spreadsheet with the same data. But if I can
get vlookup to find data in another spreadsheet, I'll be happy
as well. As long as I don't have to copy the data, with a big
chance for errors. to every new spreadsheet.
BB> sheet. The VLOOKUP() function can easily be used to search
BB> your list of names for the one you have entered and return the
BB> appropriate ingredients to the required cells.
I have been playing with vlookup a bit, and it looks very
promising.
BB> I trust this helps.
As usual you gave a very good answer :)
Groeten,
Hans.
jdh punt beekhuizen bij duinheks punt nl
--- GoldED+/LNX 1.1.5/090409
* Origin: The Wizard is using MBSE/Linux (2:280/1018)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
