Unable to fill down certain data that matches a value in a different column

[dylanvv]

Not sure if I worded that correctly but you'll be able to see what I'm talking about with the screenshot that I will provide. I have 3 columns, A,B,C. The middle one B is not important. I have multiple part numbers that have a corresponding value in column C, but only for a select few. I need to be able to fill the rest of C in with it's corresponding part number.

Example.png

Hopefully it seems clear what I want to do. I want to fill down the value in column C but only if it has the matching part number that is in column A.

Thanks in advance.

[Bernie Deitrick]

If you first sort by column C, that will put all your blanks to the bottom of column C. Select the top blank cell - let's say that the first blank cell is C25 - and enter the formula

=IFERROR(VLOOKUP(A25,A$2:C$24,3,FALSE),"")

Note how A25 is the same row, but C$24 is the row above, which has a value. For example, if the first blank cell was C456, you would use A456 and C$455.

Then copy that formula down to match column A, copy the formulas and paste-special values to get rid of the formulas, and then re-sort your table by column A. And you're done....

[dylanvv]

Hey Bernie,

Well I attempted to use the formula that you provided but the main issue is when I resort everything, then all of the corresponding values for everything seems to get all messed up. I know that I said in the initial post the the column B wasn't important but it still needs to line up with it's part number. So I don't think the formula you provided is going to work..

[Bernie Deitrick]

You need to follow all my instructions, especially the convert the formulas to values prior to re-sorting. If that does not help (it should) re-post with a picture of what you want afterwards, since it really wan't clear from your description.

[dylanvv]

Well I followed the instructions. I just don't think that I have been explaining what I need to be done very well. I'll have another picture here to demonstrate a little better. I just want to find an easy way to "fill down" the values that are in column "C" that correspond with their part number in column "A" If I did it manually it would take forever. And the main issue is that some of the part numbers don't have a value for them, so I have to skip them.

Example1.png

[Bernie Deitrick]

If you follow my step-by-step instructions. then that is exactly what you will get.