Dear Sir,
I want to find if a cell C1 is existing in columns A, B, D, or E. So I want to specify multiple discrete columns in a match function. Do you know how to accomplish this?
Dear Sir,
I want to find if a cell C1 is existing in columns A, B, D, or E. So I want to specify multiple discrete columns in a match function. Do you know how to accomplish this?
Something like this........
Formula:Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Hi Sir, thanks for your reply. Sorry that I did not not explain it clearly.
What I want to find is if cell C1 exists in any of the columns A, B, D or E. So I hope to have a formula which can incorporate columns, A, B, D, E... in a single formula, not do it in separate steps
Just adapt the ranges to your desired range like the below
Please Login or Register to view this content.
Thanks again for your reply, sir. But C1 is in column C, and I just want to ignore column C and specify it as A, B, D, E. How can I do that?
Still not clear about your requirement the suggestions are offered based on the description you have provided in your earlier posts.
Hi Sixthsense, sorry for the trouble. Basically, can I specify it as: MATCH(C1,CHOOSE({1,2,3,4},A:A,B:B,D:D,E:E),0). This does not work. Hope this explains what I look for. Thanks.
Please describe your requirement in details for better understanding instead of showing your formula
Sorry again, Sixthsense. I want to find if cell C1 exists in any of columns A, B, D, E. If it exists, then return 1; if not, return 0. I don't mind how many times C1 exist, just want to check if it is there in any of the columns A, B, D and E.
Formula:Please Login or Register to view this content.
Or
Formula:Please Login or Register to view this content.
Hi Sixthsense.
How can you find C1 in the range of A:E? Of course, it will always be there as C1 is exactly in column C. I'm afraid your answer will never work.
Last edited by BNCOXUK; 03-13-2013 at 08:16 AM.
May be like this
Please Login or Register to view this content.
Hi, nawas, your formula will always return "Match". C1 is always in A:E.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks