Hi
New to excel and this forum, need to know where Im going wrong with vlookup, if indeed its the correct route.
I have large spreadsheet 30,0000 rows deep with 3 to 4 digit branch numbers in column B2 all the way down, In column AW I need to return one of 5 possible Directors names that are responsible for these branch numbers. Each director has aprox 20 individual branches each..On a second worksheet I have a simple list , Column A17 to A77 =Branches
B17:B77=Directors names.

I have tried Vlookup but returned one name only, to column AW, with #N/A 's . clearly an error in my process . can anyone help?