Coba formula VLookUp: di sheet4 cell d3 =VLookUp( a3 , sheet3!$b$2:$h$8 , int( b3*10 - 3 ) , false ) copy ke bawah
Regards. Kid. 2011/11/3 mtsf26 <[email protected]> > ** > > > dear suhu-suhu Excel, > gan ada masalah ini.aq mo cari nilai m3 dari tabel yg ada d sheet > lain,tapi klo mo cari m3 kudu diliat panjang and diameternya seperti pada > gambar berikut: > > hxxp://i1106.photobucket.com/albums/h367/mtsf26/sheet3.jpg > > hxxp://i1106.photobucket.com/albums/h367/mtsf26/sheet4.jpg > > *ganti hxxp jadi http > tolong ya gan kalo ad yang tau jawabanna.thanks b4 > > >
