Need to autopopulate a column by matching first 3 numbers in Column A to Column B

Want to automatically populate COLUMN A with a specific Location from the LOCATIONS list in COLUMN H by matching the first 3 numbers of the Account # in COLUMN C to the associated Location Number in COLUMN G.

use
=VLOOKUP(VALUE(LEFT(C2,3)),$G$1:$H$6,2,FALSE)
in A2 and copy down

Originally Posted by ConneXionLost

Try this:

Please Login or Register  to view this content.

copy/autofill down.

This worked in the Sample I provided, however, when I placed it in the actual workbook, it gave me an NA#. The original WB is set up exactly the same.

Thank you. Yes, worked. You all make this look so easy.