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)))