anonymous
  • anonymous
Hello , Is there any body available to help me in excel formula ?
Finance
At vero eos et accusamus et iusto odio dignissimos ducimus qui blanditiis praesentium voluptatum deleniti atque corrupti quos dolores et quas molestias excepturi sint occaecati cupiditate non provident, similique sunt in culpa qui officia deserunt mollitia animi, id est laborum et dolorum fuga. Et harum quidem rerum facilis est et expedita distinctio. Nam libero tempore, cum soluta nobis est eligendi optio cumque nihil impedit quo minus id quod maxime placeat facere possimus, omnis voluptas assumenda est, omnis dolor repellendus. Itaque earum rerum hic tenetur a sapiente delectus, ut aut reiciendis voluptatibus maiores alias consequatur aut perferendis doloribus asperiores repellat.

Get our expert's

answer on brainly

SEE EXPERT ANSWER

Get your free account and access expert answers to this
and thousands of other questions.

anonymous
  • anonymous
Hello , Is there any body available to help me in excel formula ?
Finance
chestercat
  • chestercat
See more answers at brainly.com
At vero eos et accusamus et iusto odio dignissimos ducimus qui blanditiis praesentium voluptatum deleniti atque corrupti quos dolores et quas molestias excepturi sint occaecati cupiditate non provident, similique sunt in culpa qui officia deserunt mollitia animi, id est laborum et dolorum fuga. Et harum quidem rerum facilis est et expedita distinctio. Nam libero tempore, cum soluta nobis est eligendi optio cumque nihil impedit quo minus id quod maxime placeat facere possimus, omnis voluptas assumenda est, omnis dolor repellendus. Itaque earum rerum hic tenetur a sapiente delectus, ut aut reiciendis voluptatibus maiores alias consequatur aut perferendis doloribus asperiores repellat.

Get this expert

answer on brainly

SEE EXPERT ANSWER

Get your free account and access expert answers to this
and thousands of other questions

anonymous
  • anonymous
Hello, Is there any body available to help me in excel formula ?
Preetha
  • Preetha
What is your question?
anonymous
  • anonymous
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

Looking for something else?

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

More answers

anonymous
  • anonymous
if anybody can help me please help I am very much confused. if you like pls. send me directly to ID : bakaliimports@yahoo.com
anonymous
  • anonymous
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
anonymous
  • anonymous
perhaps its better to just attach the file
anonymous
  • anonymous
=HLOOKUP(E5,A:B,2,False)
anonymous
  • anonymous
sloory that should be =VLOOKUP(E5,A:B,2,False) and not HLOOKUP

Looking for something else?

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