SaraWitch
Active Member
- Joined
- Sep 29, 2015
- Messages
- 322
- Office Version
- 365
- Platform
- Windows
Afternoon peeps.
I want to look up a name (column D) on another sheet (also column D) and return the personal reference number (both column A). I am using the following but it's not working:
=VLOOKUP($D2,'Original'!$A2:$D8000,1,FALSE)
I've also tried:
=VLOOKUP($D2,'Original'!$A2:$D8000,4,FALSE)
It's returning #N/A, but the name is definitely on the other sheet! What am I doing wrong?
Any help would be greatly appreciated!
I want to look up a name (column D) on another sheet (also column D) and return the personal reference number (both column A). I am using the following but it's not working:
=VLOOKUP($D2,'Original'!$A2:$D8000,1,FALSE)
I've also tried:
=VLOOKUP($D2,'Original'!$A2:$D8000,4,FALSE)
It's returning #N/A, but the name is definitely on the other sheet! What am I doing wrong?
Any help would be greatly appreciated!