Hello, this is what i have so far. But if either of the search values from MyArr (A1 or A2) are left blank then it will search for a blank cell. How do I prevent this? Help much appreciated.
Please Login or Register to view this content.
Hello, this is what i have so far. But if either of the search values from MyArr (A1 or A2) are left blank then it will search for a blank cell. How do I prevent this? Help much appreciated.
Please Login or Register to view this content.
Consider to use If condition in
Please Login or Register to view this content.
Best Regards
MaczaQ
---------------------------------------------------------------------------------------------------------------------------
If you are satisfied with the solution(s) provided, please mark your thread as Solved
If you are pleased with my answer consider to rate it. To thank someone who has helped you, click on the star icon below their name.
- This way you will add him some reputation points ... thanks in advance.
Thanks MaczqQ, so simple just couldnt see it. Have one other question, but will repost so I can mark this as solved. Thanks again
---------- Post added at 11:30 AM ---------- Previous post was at 11:27 AM ----------
How do I rate using scales? Where is the icon?
Hi ANDREWA
You can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks