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, Bachelor's Degree
Category: Microsoft Office
Satisfied Customers: 9666
Experience:  Bachelor of Science - Engineering Consultant
53785
Type Your Microsoft Office Question Here...
John D is online now
A new question is answered every 9 seconds

Excel 2003 -- Trying to use if function but its not working.

Customer Question

Excel 2003 -- Trying to use if function but it's not working. I have two columns of zip codes. If one of the zip codes matches any of the zip codes in the other column, I want an x entered in column.

=if(j2=v1:25, x""")

It's not working with the range. I'm tired and my brain has stopped working. I need help.
Submitted: 5 years ago.
Category: Microsoft Office
Expert:  John D replied 5 years ago.

Hi,

 

Here is the formula for that

 

=IF(COUNTIF(V1:V25,J2)>0,"x","")

 

Hope this is ok. Let me know if you have any questions, and thank you for clicking Accept if you are satisfied with the solution

 

Customer: replied 5 years ago.
It's not working -- I don't want to count the zip codes, i want an x in the column beside the zip if there is a match. I'm attaching my spreadsheet so you can see what I"m doing.

Attachment: 2011-10-28_050458_drivers_100_miles_of_rockport.xls

Expert:  John D replied 5 years ago.

You didn't make that clear. I merely corrected your formula

 

No problem, will check that file, in the meantime you can go ahead and accept

 

Thank you

 

 

 

 

Customer: replied 5 years ago.
Don't mean to sound insulting, but I will "accept answer" when I get an answer that works.
Expert:  John D replied 5 years ago.

Ok

 

Are these the desired results?

 

graphic

 

John D and other Microsoft Office Specialists are ready to help you
Expert:  John D replied 5 years ago.

Thanks

 

Here is the file with the formulas

 

http://wikisend.com/download/637010/2011-10-28_050458_drivers_100_miles_of_rockport 1.xls

 

 

As you will it is more or less the same formula that I gave you first.

 

Let me know if you have any questions

 

 

Customer: replied 5 years ago.
THANK YOU!!!!!
Expert:  John D replied 5 years ago.

You're welcome. Glad to help