how to copy cell ranges

[Ralph A. Moeritz]

Hi,

I have a spreadsheet like so:

Worksheet 1:
--------------------------------
MAGIC | CONTACT | EMAIL
17 | Foo | (e-mail address removed)
....

Worksheet 2:
--------------------------------
MAGIC | COMPANY | QTY | BLAH
12 | Bambi | 3 | foz
....

I want to lookup the `MAGIC' field of Worksheet 2 and copy
the `CONTACT' and `EMAIL' fields for the matching row
in Worksheet 1 to Worksheet 2. I've tried using the DGET
macro which seemed to be perfect for this sort of thing,
but the problem is that it requires the cell containing
the column name to be _above_ the value to match.

Any ideas on how to code this up as a VBA macro?

Regards,
Ralph

 

[olasa]

The function is called =VLOOKUP(...)
To learn how to use it, watch this video:
http://www.datapigtechnologies.com/flashfiles/vlookup.html

HTH
Ola Sandström

 

[Summer]

I tried to see this video, but all I received was audio. Can someone tell me
if it is because I have only fast dial-up instead of broadband? If so, I
will be getting broadband ASAP because I am a "visual" learner and this
would be a *great* learning resource for me.
--
Summer (no valid email)
Thought ~
If you stop to kick at every dog that barks at you, you'll never get very
far.

message |
| The function is called =VLOOKUP(...)
| To learn how to use it, watch this video:
| http://www.datapigtechnologies.com/flashfiles/vlookup.html
|
| HTH
| Ola Sandström
|
|
| --
| olasa
| ------------------------------------------------------------------------
| olasa's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=17760
| View this thread: http://www.excelforum.com/showthread.php?threadid=379012
|

 

[Dave Peterson]

I didn't click on the link, but Debra Dalgleish has some instructions at:
http://www.contextures.com/xlFunctions02.html