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

A Zorbas	DONIT001
ACM	DONIT002
Nielsen	DONIT003
Action Global	DONIT004

<tbody>
</tbody>

Donations

A Zorbas	DONIT001
ACM	DONIT002
Nielsen	DONIT003
Action Global	DONIT004
Action Global	#N/A
Action Global	#N/A
Action Global	#N/A
Action Global	#N/A

<tbody>
</tbody>

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.