Re: [belajar-excel] yang tampil baris terpilih [1 Attachment]

Thu, 11 Oct 2018 04:58:36 -0700 

Dear Topenk
Sesuai arahan Mas Kid, pakai Vlookup
=VLOOKUP(C2,A5:B368,2)
pakai Index juga bisa:
=INDEX(B5:B368,C2)
pakai Lookup juga boleh
=LOOKUP(C2,A5:A368,B5:B368)

On 10/11/2018 12:27, 'Mr. Kid' [email protected] [belajar-excel] wrote:

Pakai vlookup
On Oct 11, 2018, at 11:05, Topenk Baday [email protected] <mailto:[email protected]> [belajar-excel] <[email protected] <mailto:[email protected]>> wrote: 


yang tampil baris terpilih
<CAri ROw.xlsx>

Attachment: Kopi CAri ROw-4.xlsx
Description: MS-Excel 2007 spreadsheet

Kirim email ke