Hi, I'm trying to find a solution to my problem, in fact I have worked on this before, but I don't remember how to solve it.
Basically I want to fill an array, looking up information on two columns..and when there is a match in both, I need a 1 to display, and a 0 otherwise.
There is an example attached, It's far more clear than any explanation.
I would really appreciate your help.
Thanks in advance.
Try:
=--ISNUMBER(MATCH(1,INDEX(($A26=$A$2:$A$5)*(B$25=$B$2:$B$5),0),0))
copied down and across..
Note: You have Brazil spelled 2 different ways.. make them consistent.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Hi,
I'm assuming the 1's in the result come from the C2:C5 values.
In a helper cell D2 and copied to D5
In B14 and copied across and down your table.
Please Login or Register to view this content.
HTHPlease Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thanks a lot! the solution works perfect
And thanks for the advices too!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks