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
53785
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: 5 years ago.
Category: General
Expert:  John D replied 5 years ago.

Hi,

 

Here you go

 

=IF(H4>0,INDEX(AB525:AB779,MATCH(H4,AC525:AC779,0)),"")

 

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

 

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

Related General Questions