A community for students.

Here's the question you clicked on:

55 members online
  • 0 replying
  • 0 viewing

anonymous

  • 5 years ago

Hello , Is there any body available to help me in excel formula ?

  • This Question is Closed
  1. anonymous
    • 5 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Hello, Is there any body available to help me in excel formula ?

  2. Preetha
    • 5 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    What is your question?

  3. anonymous
    • 5 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Please help me in this regard I have a problem in excel please assist me. A Text Range is present in Cell A1 to A20 in front of that a different Text Range is Present in Cell B1 to B20. and the Text Showing Cell is E5 I want that if the Cell E5 is equal to A1 then the result must be what is present in B1 (in the Target Cell E15) Rest of all results of A2 to A20 exactly like that I have entered the following formula but it accepts only 8 times not more then that (otherwise it gives an error of FALSE) =IF(E5=A1,B1,IF(E5=A2,B2,IF(E5=A3,B3,IF(E5=A4,B4,IF(E5=A5,B5,IF(E5=A6,B6,IF(E5=A7,B7,IF(E5=A8,B8)))))))) Please tell me the correct formula of it. I shall feel great obliged to you. An early reply will highly be appreciated. Thanking you in advance. Heyrose

  4. anonymous
    • 5 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    if anybody can help me please help I am very much confused. if you like pls. send me directly to ID : bakaliimports@yahoo.com

  5. anonymous
    • 5 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Hello, Dear Friends Please Help me in to enter the right Excel Formula in my sheet. I am very much confused. if anybody can help me please help I am very much confused. if you like pls. send me directly to ID : bakaliimports@yahoo.com

  6. anonymous
    • 5 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    perhaps its better to just attach the file

  7. anonymous
    • 5 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    =HLOOKUP(E5,A:B,2,False)

  8. anonymous
    • 5 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    sloory that should be =VLOOKUP(E5,A:B,2,False) and not HLOOKUP

  9. Not the answer you are looking for?
    Search for more explanations.

    • Attachments:

Ask your own question

Sign Up
Find more explanations on OpenStudy
Privacy Policy

Your question is ready. Sign up for free to start getting answers.

spraguer (Moderator)
5 → View Detailed Profile

is replying to Can someone tell me what button the professor is hitting...

23

  • Teamwork 19 Teammate
  • Problem Solving 19 Hero
  • You have blocked this person.
  • ✔ You're a fan Checking fan status...

Thanks for being so helpful in mathematics. If you are getting quality help, make sure you spread the word about OpenStudy.

This is the testimonial you wrote.
You haven't written a testimonial for Owlfred.