Hello and welcome to Just Answer. My name is Wes and I will be assisting you today.
Do you have a a large number of values you need to check for in those cells?
If you have a large number of values you are searching for (a list of names you want copied), you can list out those names or values in a column on the spreadsheet somewhere and use the VLOOKUP function.For example I have a list of names including the ones you mentioned in column L from Row 5 to 50.Then in the A column I use this function to see if the name in the D column is in that list, and if so, it returns the value in C.=IF(ISNA(VLOOKUP(D6,L3:L48,1,FALSE)),"",C6)The way it works is it uses the VLOOKUP function to find out if the value in D6 is in the list of names in the array in Column L. If it is, it would return that name. If it doesn't find it, it returns an error code "#N/A". So, any value other than #N/A means we found the name, so that is what we test for. Make sense?
The array is from L3 to L48, not 5, to 50 as I initially said. It doesn't really matter though, you can use whatever range you want.
Hi Wes Thanks for your reply. Could you simplify your answer for me.
Hi Wes Many thanks for your reply, however is it possible for you to simplify your answer as I do not understand. I have attached an excel sheet. Cell A10 shows the formula I was trying to use in column g2 to g10. Thanking you in anticipation Paul Grant
Is this what you are looking to have happen?
Actually here is the corrected formula as it is in G2
If a name in the D column isn't in the L column, the corresponding cell in G will be blank
I might need you to better detail the result you are trying to achieve