Excel help needed.

  • Thread starter Thread starter razibhasan
  • Start date Start date
R

razibhasan

Greetings!
I am learning Excel myself. Right now I'm in a problem doing something
I have a workbook with three columns. Column 1 contains Email addresses
Column 2 contains First Name and Column 3 contains Last Name.

My second workbook contains only email addresses (a few) from firs
work book. How I can get other fields easily from first workbook?
mean first name and last name?

Can anyone help me regarding this?

Any help will be appreciated.

Regards
 
Any formula that you use will need to contain the path to the other WB
within that formula.
Since you're learning XL, it's easier to let XL create that path for you
automatically.

Let's say we use the Vlookup() function to retrieve the data.

Say WB1 has column headers in:
A1 - :E-mail Addr
B1 - F. Name
C1 - L. Name
say data is in A2 to C100.

WB2 has *exactly* the same headers.

Open both WBs.

On WB2, in B2, enter:
=Vlookup(A2,
NOW, navigate to WB1,
Click in A1,
Scroll down to Row100,
Hold down <Shift>,
And click in C100.
(Look in the formula bar, and you'll see that XL filled in the path and the
range for you.)
Now, click in the formula bar after the C100, and enter:
,2,0)
And hit <Enter>.

You have your first formula done, returning the first name of the matching
e-mail address in A2.

Your formula might look like this:

=VLOOKUP(A2,WB1!A1:C100,2,0)

Let's add some absolutes so that the formula can be copied without
distorting the ranges:

=VLOOKUP($A2,WB1!$A$1:$C$100,2,0)

Now, copy this formula to C2, and change the column index number to 3:

=VLOOKUP($A2,WB1!$A$1:$C$100,3,0)

You should now have both name for the matching e-mail address.

Select both B2 and C2, and copy that 2 cell selection down, as far as
needed.

When you close WB1, you'll see that the formulas will get longer, reflecting
the *full path* to that closed WB1.

Post back if you wish to include error traps to eliminate #N/A when no data
match is found.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------




Now copy
 
Back
Top