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 John D Your Own Question

John D
John D, BS Degree in Engineering.
Category: General
Satisfied Customers: 9666
Experience:  Math, science and 25 years experience in computer programming
Type Your Question Here...
John D is online now
A new question is answered every 9 seconds

I need an Excel formula to do the following: If the value

Resolved Question:

I need an Excel formula to do the following:

If the value in cell H4 is greater than 0,
Search cells AC525 to AC779 to match the number in H4
When a match is found, enter the value from the matched cell immediately to the left of the AC cell (AB) into cell G4.
Submitted: 4 years ago.
Category: General
Expert:  John D replied 4 years ago.



Here you go




Hope this is ok. Let me know if you have any questions


John D and 37 other General Specialists are ready to help you