lookup gambar
TRANSCRIPT
Nama Gambar ( kode) Gambarnya
kardusgalau
tebakgambar
telorlucu
Pilih Gambartebakgambar
D6
Reimundo, Raynaldo: bebas, bisa pakai rumus lookup, pake down list atau lain2. (c/o: pakai down list)
1. copy paste gambar pakai linked picture
Masuk formula > name manager > masukin rumus dibawah=INDEX('Database Pic'!$B$3:$B$5,MATCH(Dashboard!$D$6,'Database Pic'!$A$3:$A$5,0))
=INDEX('Database Pic'!$B$3:$B$5,MATCH(Dashboard!$D$6,'Database Pic'!$A$3:$A$5,0))