Formula to auto-fill Index/Match not working

Job # is in the W column ex: 783

What I need is the cell in A13 to define what the COA# is based on the Job# entered per day. Example : Car Rental associated with 783 will be 4600-1000, but Car Rental associated with 775 will be 8600-0000. Anything associated with 775 will have a different overhead code that isn't billable so the COA#'s are different. Any other Job# will be billable so it gets a different COA#

Thanks, but no, because I need it to look up more than those two COA#'s. That was just an example. Equipment Rentals associated with 775 will be 8470-0000 but any other job # will be 8220-0000 and so on and so on. I can segregate the one list into 2 different columns so the formula can pull from one for 775 and the other for everything else. This is just frustrating me to no end.

Here you go.

Revised Job Expense.xls

Ok, what I have done is alter the selection criteria for column A by identifying it with either 775 or WIP before the selection and have segregated the COA #'s into 2 columns for searching. Should I use an IF/MATCH? All help is GREATLY appreciated!