• 100% Satisfaction Guarantee

Wes, Consultant
Category: Software
Satisfied Customers: 958
Experience:  Bachelor's Degree in Computer Science, 15+ years experience.
63083622
Wes is online now

# I tried earlier this evening, but my computer timed out when

### Customer Question

I tried earlier this evening, but my computer timed out when trying to send deposit.
So here goes again.

I am currently using the formula below

=IF(AND(D6="Somerset T"),C6,"")

However I wish to extend the formula to include further D6 =.

I am trying to say if D6 says either Somerset T, Lydia, and others, then copy C6 into the cell with the formula.
I hope you can understand my question. Many thanks Paul
Submitted: 2 years ago.
Category: Software
Expert:  Wes replied 2 years ago.

Wes :

Hello and welcome to Just Answer. My name is Wes and I will be assisting you today.

Wes :

Do you have a a large number of values you need to check for in those cells?

Wes :

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?

Wes :

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.

JACUSTOMER-hjjcwt9e- :

Hi Wes

JACUSTOMER-hjjcwt9e- :

JACUSTOMER-hjjcwt9e- :

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

 Full Size Image

Wes :
Wes :

Is this what you are looking to have happen?

Wes :

Actually here is the corrected formula as it is in G2

Wes :
Wes :

If a name in the D column isn't in the L column, the corresponding cell in G will be blank

Wes :

I might need you to better detail the result you are trying to achieve

### What Customers are Saying:

• My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer
< Previous | Next >
• My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer
• Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.
• This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex
• Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP
• I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin
• Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther
• Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.

• ### Steve Herrod

#### Satisfied Customers:

160
Familiar with a wide variety of software and experienced in user training/support
< Last | Next >

### Steve Herrod

#### Satisfied Customers:

160
Familiar with a wide variety of software and experienced in user training/support

### Chris L.

#### Satisfied Customers:

114
Certified Software expert with over 10 years experience.

### Jess M.

#### Satisfied Customers:

109
Computer Software Support specialist for more that 10 years

### Frederick S

#### Satisfied Customers:

91
Computer technician; founder of a home PC repair company.

### Bernie

#### Satisfied Customers:

52
6+ years experience, Microsoft MCDST/CompTia A+ Certified

### The-PC-Guy

#### Satisfied Customers:

38
20 years experience providing remote computer support