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 Jason Jones Your Own Question
Jason Jones
Jason Jones, Computer Technician
Category: Microsoft Office
Satisfied Customers: 16412
Experience:  Over 10 years work experience.
Type Your Microsoft Office Question Here...
Jason Jones is online now
A new question is answered every 9 seconds

I need to check for a column (any row in that column) has a

This answer was rated:

I need to check for a column (any row in that column) has a result of "check", how do i write this fomula


Please, don't forget that the deposit you placed to ask this question is not used to pay me until you rate my service. You are rating My Service and not this website itself or your actual issue.

Here is the formula that you are in search of:

=IF(ISNA(VLOOKUP("check",A1:A20,1,FALSE)),"Ok","pls check")

Please, keep me updated on the status of your problem if there are any further issues. I will be available to respond.

Please, bookmark the following page if you ever want to work with me directly. Any new questions posted at the following page will be sent directly to me:

Thank you,
- Jason

Jason Jones and 6 other Microsoft Office Specialists are ready to help you
Customer: replied 4 years ago.


it works, thx

Thank you for the update. Please, do not forget to rate my help below.