I have 3 columns, A,B and C.
B is a Master List of locations.
C is a Project list and is a dependent list to B.

I need a formula in column A to lookup and match B to C and return an account number from AccountNums (Named Range).

Some of the project names in column C are the same, and my current formula returns the wrong account number because it only looks at column C and matches the first project it comes to with the selected name. There may be 10 projects with the name ENHANCEMENT at 10 different locations.

My current formula:

=IF(C12="","",VLOOKUP(C12, AccountNums,2,FALSE))