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
Bookmarks