How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Wes Your Own Question

Wes
Wes, Consultant
Category: Software
Satisfied Customers: 960
Experience:  Bachelor's Degree in Computer Science, 15+ years experience.
63083622
Type Your Software Question Here...
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- :

Hi Wes Thanks for your reply. Could you simplify your answer for me.

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 :

Is this what you are looking to have happen?

Wes :

Actually here is the corrected formula as it is in G2

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.
 
 
 

Meet The Experts:

 
 
 
  • Steve Herrod

    Steve Herrod

    Computer Support Specialist

    Satisfied Customers:

    160
    Familiar with a wide variety of software and experienced in user training/support
< Last | Next >
  • http://ww2.justanswer.com/uploads/SP/spherrod/2012-6-6_174244_1000852.64x64.JPG Steve Herrod's Avatar

    Steve Herrod

    Computer Support Specialist

    Satisfied Customers:

    160
    Familiar with a wide variety of software and experienced in user training/support
  • http://ww2.justanswer.com/uploads/SE/Seashore2011/2011-12-6_33418_111205223015.64x64.jpg Chris L.'s Avatar

    Chris L.

    Support Specialist

    Satisfied Customers:

    114
    Certified Software expert with over 10 years experience.
  • http://ww2.justanswer.com/uploads/JE/jessmagz/2012-6-6_18129_jm.64x64.jpg Jess M.'s Avatar

    Jess M.

    Computer Support Specialist

    Satisfied Customers:

    112
    Computer Software Support specialist for more that 10 years
  • http://ww2.justanswer.com/uploads/FS/fszcze/2012-6-18_181848_500test.64x64.jpg Frederick S's Avatar

    Frederick S

    Computer Specialist

    Satisfied Customers:

    91
    Computer technician; founder of a home PC repair company.
  • http://ww2.justanswer.com/uploads/WA/wa94sound/2012-6-6_202633_iStock000007010121Small.64x64.jpg Bernie's Avatar

    Bernie

    Software Support

    Satisfied Customers:

    52
    6+ years experience, Microsoft MCDST/CompTia A+ Certified
  • http://ww2.justanswer.com/uploads/CH/chutz747/2011-11-6_14231_me.64x64.jpg The-PC-Guy's Avatar

    The-PC-Guy

    Software Engineer

    Satisfied Customers:

    38
    20 years experience providing remote computer support
  • http://ww2.justanswer.com/uploads/jnayes/2010-12-23_132454_japicbetter.jpg jnayes's Avatar

    jnayes

    Computer Support

    Satisfied Customers:

    37
    Network Administrator
 
 
 

Related Software Questions