Mar 22 2022 03:28 AM
Hello,
Ive written this formula, I just need to make it such that when you drag down the +1 goes to +2 then +3, +4 etc etc
=INDEX('UNID Reference'!L:L,IF(INDEX(B:B,MATCH(D5,A:A,0))="Generate New INST UNID",(COUNTA('UNID Reference'!B:B))+1,B3))
I've underlined and bolded the '+1' I'm referring to.
Thanks
Mar 22 2022 03:39 AM
=INDEX('UNID Reference'!L:L,IF(INDEX(B:B,MATCH(D5,A:A,0))="Generate New INST UNID",(COUNTA('UNID Reference'!B:B))+ROW(A1),B3))
Maybe with +ROW(A1) instead of +1 and +2.