Adam Schuman
New member
K, I will try and type out what i am doing...
When a cell in column A equals 401 then take that same row's column C's number.
at first i thought something like this =IF(A:A=401,RC2)
That equation says if column A has a cell that = 401, then go 2 columns over and use that cell....but this doesn't work.
I have no idea when it will equal 401, that is why i need it to find it, and when it does, then take that very same row's number from column C
AHH, i am getting mad just typing it.
When a cell in column A equals 401 then take that same row's column C's number.
at first i thought something like this =IF(A:A=401,RC2)
That equation says if column A has a cell that = 401, then go 2 columns over and use that cell....but this doesn't work.
I have no idea when it will equal 401, that is why i need it to find it, and when it does, then take that very same row's number from column C
AHH, i am getting mad just typing it.