• 100% Satisfaction Guarantee
Wes, Consultant
Category: Software
Satisfied Customers: 967
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: 3 years ago.
Category: Software
Expert:  Wes replied 3 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