VLOOKUP

  • Thread starter Thread starter bstacy
  • Start date Start date
B

bstacy

I cannot get the VLOOKUP function to work for the life of
me. I have never used it before, but I have a perfect
application for its function.

I have one spreadsheet (A) with a list of names. I have
another spreadsheet (B) with a list of names and several
columns of financial information. The financial
information I need is in column M. I need to match the
names in (A) with the names in (B) and return the value
from column M into (A) from the matched name in (B).

How do I get VLOOKUP to do this?
 
bstacy said:
I cannot get the VLOOKUP function to work for the life of
me. I have never used it before, but I have a perfect
application for its function.

I have one spreadsheet (A) with a list of names. I have
another spreadsheet (B) with a list of names and several
columns of financial information. The financial
information I need is in column M. I need to match the
names in (A) with the names in (B) and return the value
from column M into (A) from the matched name in (B).

How do I get VLOOKUP to do this?
Click to expand...

Suppose your names were in columns A of both sheets, and you want your
results in column C of SheetA. Suppose also that there were 100 rows
populated in SheetB. In cell C1 of SheetA put the formula
=VLOOKUP(A1,SheetB!$A$1:SM$100,13,0)
and copy it down column C as far as required.
 
Back
Top