Hi
i want to find value of index on the table on the right to fill in column D
Capture.PNG
here is my fomular in K2 :
=INDEX(H2:H7,MATCH(1,(A2=G2:G7)*(C2=I2:I7),0))
need help because it does not work.
Also , how can i make it dynamic if the size of table on the right will change ? can i use G:G , I:H or H:H
Thanks
Bookmarks