VLOOKUP doesn't return values when cell is text and has duplicates

[Daithi]

Hi

I have two worksheets, Unique Donors & Donations. I've assigned a unique alphanumeric code to each Donor and need to return that value against their Donations. VLOOKUP returns the first 3 values bu when it comes to a repeated value it stops. Amy help here much appreciated

Unique Donors

[TABLE="width: 926"]
<tbody>[TR]
[TD]A Zorbas[/TD]
[TD]DONIT001[/TD]
[/TR]
[TR]
[TD]ACM[/TD]
[TD]DONIT002[/TD]
[/TR]
[TR]
[TD]Nielsen[/TD]
[TD]DONIT003[/TD]
[/TR]
[TR]
[TD]Action Global[/TD]
[TD]DONIT004[/TD]
[/TR]
</tbody>[/TABLE]

Donations

[TABLE="width: 737"]
<tbody>[TR]
[TD]A Zorbas[/TD]
[TD]DONIT001[/TD]
[/TR]
[TR]
[TD]ACM[/TD]
[TD]DONIT002[/TD]
[/TR]
[TR]
[TD]Nielsen[/TD]
[TD]DONIT003[/TD]
[/TR]
[TR]
[TD]Action Global[/TD]
[TD]DONIT004[/TD]
[/TR]
[TR]
[TD]Action Global[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD]Action Global[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD]Action Global[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD]Action Global[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
</tbody>[/TABLE]


I only know the most basic VLOOKUP and using=VLOOKUP(A2,'Unique Donors'!A2:B533,2,FALSE)

 

[steve the fish]

You need to absolute the cells in the lookup range

'Unique Donors'!$A$2:$B$533

 

[Daithi]

Brilliant!!! I won't pretend to know what "Absolute" means. That's my homework, Really, really appreciate the speedy reply

 

[steve the fish]

It just fixes then into position so they dont change when you drag the formula down. The fact they will change if not absoluted was your problem.