lookup gambar

6
Nama Gambar ( kode) kardusgalau tebakgambar telorlucu

Upload: ido-damos-joel

Post on 19-Feb-2016

213 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: Lookup Gambar

Nama Gambar ( kode) Gambarnya

kardusgalau

tebakgambar

telorlucu

Page 2: Lookup Gambar
Page 3: Lookup Gambar

Pilih Gambartebakgambar

D6
Reimundo, Raynaldo: bebas, bisa pakai rumus lookup, pake down list atau lain2. (c/o: pakai down list)
Page 4: Lookup Gambar

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

Page 5: Lookup Gambar

=INDEX('Database Pic'!$B$3:$B$5,MATCH(Dashboard!$D$6,'Database Pic'!$A$3:$A$5,0))