=IF(AND('tube base'!A2:A60000,'participants names'!a1,IF(AND('tube base'!G2:g60000,'Participants names'!B4,'tube base'!H2
the above formula (If i have the formula right should return the data found in H2),
what im trying to do is to get the data in "tube base h2" from the criteria in tube base and participants match when they do it returns the result found.. i will be dragging the result down
or have i the wrong formula altogether
TIA
Bookmarks