Ask a Question, Get an Answer ASAP!

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

Answered by:John D
BS Degree in Engineering.
Positive Feedback: 100.0 %
Accepted Answers: 108

in General

Recent Feedback

Positive

Quick Response and great help!

Customer 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: 345 days and 12 hours ago.

Category: General

Value: $19

Status: CLOSED

Accepted Answer

Expert: John D replied 345 days and 11 hours 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

Expert Type	BS Degree in Engineering.
Category:	General
Pos. Feedback:	100.0 %
Accepts:	108
Answered:	5/31/2012

Experience: Math, science and 25 years experience in computer programming

Ask this Expert a Question >

145 Experts are Online Right Now

General Questions	Date Submitted
How Can I Insert My Maiden Name, My Old Class Mates Are Not	5/6/2013
I am looking for someone to help me with this assignment.	5/2/2013
1. A(n) __________ is a personal representative named by the	5/1/2013
1) Big Fizz Co., a manufacturer of cola-flavored drinks, wants	4/30/2013
Many organizations have been in the news over the past few	4/29/2013
vintage toys and hobbies I need someone who knows vintage Trains.	4/29/2013
general partner contributions to a limited partnership	4/29/2013
The United States generally taxes U.S. source fixed and determinable,	4/26/2013
Which of the following is not one of the Complete Auto Transit's	4/26/2013
I have a general electrical dryer and i want to change it to	4/23/2013

RSS

Next 10 >

Ask an Expert

Type Your Question Here...

characters left:

Top General Experts

See More Experts

In The News

Learn More

How It Works

Ask an Expert
Get a Professional Answer
Ask Followup Questions
100% Satisfaction Guarantee

Learn More

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.