hello i have a problem ive only managed to incorporate two buttons in my search function.
dont know how to get the third one.
my idea is when you press the button 20bb and the button UTG 9H and then 50/100 it would search out the correct anwser in this case QQ+. THE CODE IS WRITTEN OVER THE PICTURE. so my question is what do i need to add to get this to work
=VLOOKUP(J2,OFFSET(A$16,MATCH(K$2,A$17:A$782,0),1,COUNTIF(A$17:A$782,K$2),2),2,0)
dont know how to get the third one.
my idea is when you press the button 20bb and the button UTG 9H and then 50/100 it would search out the correct anwser in this case QQ+. THE CODE IS WRITTEN OVER THE PICTURE. so my question is what do i need to add to get this to work
=VLOOKUP(J2,OFFSET(A$16,MATCH(K$2,A$17:A$782,0),1,COUNTIF(A$17:A$782,K$2),2),2,0)
Last edited: