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
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.



Here is the formula for that




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.



Are these the desired results?




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



Here is the file with the formulas 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.
Expert:  John D replied 5 years ago.

You're welcome. Glad to help