LinkBack URL
About LinkBacks
Hi folks
Another one of these
I have attached a workbook to better explain my need.
Cheers
hammer
Hi folks
Another one of these
I have attached a workbook to better explain my need.
Cheers
hammer
=(COUNTIF(INDEX(Sheet2!$A$2:$BA$29,,MATCH(BL$1,Sheet2!$A$1:$BA$1,0)),$J2)>0)*K2
Try this formula
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Hi Siva
Right now the formula is returning every value. I need it to return '1' only when Col K has the value 1 in each row. Formula to return "" if no match.
Thanks
hammer
ps I just added =1 to the K2 which works but returns True or False
=IFERROR((MATCH($J2,INDEX(Sheet2!$A$2:$BA$29,,MATCH(BL$1,Sheet2!$A$1:$BA$1,0)),0)>0)*1,"")
then try this
Now we are getting '1' in every cell
If the identical heading in Col K has the value "1" in K2 and the identical heading in Sheet2 has a match in the same Col for Col J2 then I want the formula to return "1" in BL2
The Values in Column J Matching with Sheet2 so it is giving 1
Tell me in which case the formula returning the wrong answer / result
Should only return 1 when Col K has 1 and J is matched under the Pr1Rank heading in Sheet2
The first formula works when I put k2=1 but it returns True or False in lieu of 1 or ""
will you please give me your expected result for Column BL and BM
It's okay Siva I can work it with TRUE/FALSE thanks.
Thanks again for your assistance.
=IFERROR((MATCH($J2,INDEX(Sheet2!$A$2:$BA$29,,MATCH(BL$1,Sheet2!$A$1:$BA$1,0)),0)>0)*1,"")
then try this
I think this formula will not give true/false
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks