I have duplicate field values - in need of a formula

On Spreadsheet A I have 2 columns, one displaying Employer ID #'s and School Districts, ranging from A2:B63.
On Spreadsheet B I have just the Employer ID #'s; however, I have duplicates in these fields, and they are necessary because they belong to different employees.

For the below formula, here is a key to understand the data:
C2 = Employer ID on Spreadsheet B
'Employer Data'!A2:B63,2,FALSE = Spreadsheet A information.

I've tried =VLOOKUP(C2,'Employer Data'!A2:B63,2,FALSE) but that only provides me with the first result of all the duplicate Employer ID #'s, the rest result in #N/A.

Is there any formula that I can use that will help me get around this duplicate error?

Thanks in advance!

Check the format of ID's. If you lookin' number (C2) but col col A has a text format - formula say: #N/A, and vice versa.
C2 and col A on sheet 1 should have the same format.

Sandy, thank you for your reply!

I've been Google searching for this issue for a couple of days and your suggestion was one that I came across already. Both are in general format, but the issue seems to be with VLOOKUP.

could be fine to see any example file (xlsx not picture)

My goodness! That did it!

What does adding the $ sign in front of the search criteria do to the formula?

you mean C2 > $C$2 or $A$2:$B$63
C2 should be as iis because if not you will get always the same result
$A$2:$B$63 should be with $$ because if not you will get changed range every row , A2:B63, A3:B64, A4:B65, and so on, and every time you move the range down out of data

check without $$ , drag formula down and select middle cell , click on formula in formula bar . it will highlight ranges in use

Thanks for rep and don't forget mark thread as SOLVED. Thank you