Google sheet useful Functions:
=QUERY(DSDKGEN1!$B$2:$P$230;"SELECT B WHERE F contains ' "&INDIRECT("R[0]C6";FALSE)&" ' LIMIT 1";0)
Get B from sheet DSDKGEN1, if F column have same value with Row[0] Column 6 of current sheet
=QUERY(DSDKGEN1!B2:AB230;"SELECT B, C, F, E, N WHERE Q=TRUE OR R=TRUE LIMIT 100";0)
Link google thông thường
https://drive.google.com/file/d/17udkXOrGkU-l3gpfdoBW0SEUtXxCdtNo/view?usp=sharing
=IMAGE("https://drive.google.com/uc?id="& MID(INDIRECT("R[0]C2";FALSE);SEARCH("/d/";INDIRECT("R[0]C2";FALSE))+3;SEARCH("/view";INDIRECT("R[0]C2";FALSE))-SEARCH("/d/";INDIRECT("R[0]C2";FALSE))-3))
Với link google ko có View
https://drive.google.com/file/d/1yS6rLDbCY40Hf7MwBnTVU_zfZYSYs07z
="https://drive.google.com/uc?id="& MID(INDIRECT("R[0]C2";FALSE);SEARCH("/d/";INDIRECT("R[0]C2";FALSE))+3;LEN(INDIRECT("R[0]C2";FALSE))-SEARCH("/d/";INDIRECT("R[0]C2";FALSE)))