LOOKUP PROBLEM

  • Thread starter Thread starter aha09
  • Start date Start date
A

aha09

Okay, I have a list of lastnames (no duplications of lastname) of 60
persons and there is a dollar amount associated with each persons name
(representing their contribution). Now on another sheet, I have a
list of 200 persons lastnames (no duplications here either).

Now what I would like is to have excel go thru the list of 200 persons
names and place the dollar amount next to each persons name (ONLY IF
THEY ARE ON THE LIST OF 60 NAMES), otherwise, just put not applicable
(N/A).

How do I do this?
 
If the original data is in Sheet1, range A1:B60

In the second sheet cell B1, next to the 200 (range
A1:A200) names type:

=vlookup(B1,Sheet1!$A$1:$B$60,2,0)

Copy down the formula.

Regards,
Felipe
 
Example
xl File1
Starts on row 10
Col A - Last Name of 60
Col B - First Name of 60
Col C - Dollar Amount

In another file
xl File2
Starts on row 15
Col A - Last Name
Col B through E - Other stuff
Col F - where you wan the result of the lookup.

Then in cell F15 I would put
=VLOOKUP(A15,[File1]Sheet1!$A$10:$C$59,3,0)

I am assuming Sheet1 is the worksheet name in file 1.
When you type =VLOOKUP( then you can use the arrow keys
for reference to the cells

The 3 is that is the offset position in file 1

That should do it.

Steven
 
Try this formula in the next column of the 200 names and fill down.

=IF(ISNA(VLOOKUP(A1,Sheet1!$A$1:$B$60,2,0)),"N/A",VLOOKUP(A1,Sheet1!$A$1:$B$
60,2,0))

Adjust the ranges to match the sheet.

HTH
Regards,
Howard
 
Back
Top