Hai Dede, File terlampir dengan tabel referensi yang disusun agak berbeda. Direkomendasikan menggunakan beberapa cells bantu dibanding menggunakan sebuah formula langsung, karena banyak bagian formula yang digunakan berulang-ulang oleh sebuah formula untuk sebuah cells. Apalagi jika formula tersebut akan digunakan di banyak cells.
Wassalam, Kid. On Mon, Mar 2, 2015 at 3:46 PM, Dede pmaho_l...@nabatisnack.co.id [belajar-excel] <belajar-excel@yahoogroups.com> wrote: > > > Dear BeExceler, > > > > Mohon masukan terkait file terlampir. > > > > Salam, > > DD > > ------------------------------ > This e-mail and any files transmitted with it are confidential and > intended solely for the use of the individual to whom it is addressed. If > you have received this email in error please send it back to the person > that sent it to you. Any views or opinions presented are solely those of > its author and do not necessarily represent those of NABATI or any of its > subsidiary companies. Unauthorized publication, use, dissemination, > forwarding, printing or copying of this email and its associated > attachments is strictly prohibited. > > >
re-vlookup.xlsx
Description: MS-Excel 2007 spreadsheet