VLOOKUP Function Question

  • Thread starter Thread starter JimFor
  • Start date Start date
J

JimFor

Hi,
I need to use the VLOOKUP function to lookup and paste into a file two columns
of data. Here is what I am faced with. I have one file with account numbers.
(Thanks to the answers in the "Number Question" thread, I can now sort those
numbers :>)). I need account names and Tax ID numbers for each account number.
These two groups of numbers are in another file. That file contains three
columns. One with account names, one with tax ids and one with account
numbers, I believe. (Not sure of the order.) As of now, I make two new columns
in my sheet and title them "Account Name" and "Tax ID." I then notifiy someone
in the organiation who then uses (he says) the VLOOKUP function to provide
names and IDs for the entire list of account numbers. I would like to be able
to do this myself instead of having to wait for him. He delays in telling
anyone how he does it. Even "higherups." Says it is very complex. I don't
believe him. (VERY strange power/political situation in this area?)

So...how does he do it? He delivers two columns of Account Names and Tax IDs
which correspond to a column of Account Numbers.

Thanks
 
Suggest you work your way through the Help for Vlookup.
The source files for the lookup must have the account #'s (the "Key") in
the leftmost column.
 
Assume that you have the following table in Sheet1:

Column A : Account Number
Column B : Account Name
Column C : Tax ID

In Sheet 2, assume that this is where you will enter the Accoun
Number.
If the "Account Number" is entered in Cell A2, then enter the followin
in:

Cell B2 =VLOOKUP(A2,Sheet1!$A$2:$C$100,2,0)

and this will give you the "Account Name" that corresponds to th
"Account Number" in Cell A2. Copy this formula down until you
requirements are met.

Cell C2 =VLOOKUP(A2,Sheet1!$A$2:$C$100,3,0)

and this will give you the "Tax ID" that corresponds to the "Accoun
Number" in Cell A2. Again, copy this formula down until you
requirements are met.

NOTE: The range *$A$2:$C$100 * must be adjusted to suit the actua
range of your table.

Hope this will help you ...
 
Nothing is really that complicated if you know how to go about doing it
Now, you can prove to your officemate that his VLOOKUP process is no
that complex!!!
 
Back
Top