Hello

if you do the following it should give you what you need based on your example......

Assuming column A is the "lookup" value and Column C is the cell that needs to be filled.........


Sort the data by column A and then C. A can be sorted in any way but C must be sorted to show the populated values at the top.

Highlight Column C from the first Cell that needs to be populated down to the bottom.

Now click "Find & Select" from the "Home" tab, then "Go To Special" and choose "Blanks"

Now Type "=" (without quotes) and press the Up arrow

Press CRTL and Enter and it should populate all the values for you.

Hope this helps

Cheers

Jim