joing (merge) tables by key field
 

Hi!
How can I joing (merge) tables by key field like in DBMS?

Can't find any suitable solutions. Only by some stupid tricks, but I don't
like it and it's not handy to use...

Also found http://www.digdb.com/ add-in, but it costs money :)

Thanks.

Maybe =vlookup() or =index(match()) would be what you want.

You could look at Debra Dalgleish's site:
http://www.contextures.com/xlFunctions02.html
and
http://www.contextures.com/xlFunctions03.html

Alex Kachanov wrote:

Hi!
How can I joing (merge) tables by key field like in DBMS?

Can't find any suitable solutions. Only by some stupid tricks, but I don't
like it and it's not handy to use...

Also found http://www.digdb.com/ add-in, but it costs money :)

Thanks.

--

Dave Peterson