Formula to put a number into cells that match

[BigTandthepc]

Hi Everyone,

Ok, so I think once i've got this I'm done!

In Colum "N" the data is either Blank or says "All Correct" In Q is the Clients Name, I need a formula That will look at the name in "Q" and if it matches a Name with "all correct" in its row to input "Done" if Not then "NOT DONE"

Table for example of the results I want is below, please help if you can.

	N	Q	AB
	All Correct	ABBOTS	Done
		Abbots	Done
		Jones
		Abbots	Done
		Jones
		Jones
		Jones

So as you can hopfully see above, one of the records for abbots has "All correct" in it so all records for abbots have "Done" in ab, however none of the records for Jones have "All Correct" in N so theres nothing.

please help me.

[oeldere]

Mayby this way (see the example).

It has saved me time, if you had put an excel-example instead of a table.

Please reply if this is what you're up to.

[BigTandthepc]

Hello,

Thank you so much, that is exactly what I needed.

I would never have worked that one out.

thanks again

Brilliant!