I am trying to write a formula looking at the last value of an number, and if
that
number equals a certain value, copy a different reference cell into a new
cell.

Example
A B C D E
32002.001 ACT A 3858233.29 =IF(A1.....) =IF(A1.....)
32002.002 ACT B 2864212.29

I AM TRYING TO WRITE A FORMULA THAT WILL ONLY LOOK AT THE LAST NUMBER OF THE
A COLUMN VALUE, AND IF THAT VALUE IS MET, WILL COPY THE VALUE FROM THE C
COLUMN INTO THE FORMULA CELL OR OTHERWISE LEAVE THE FORMULA CELL BLANK.