Mungkin klo pake =index(array;row(match(lookup;array;match type));colom) Bisa lebih presisi
From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: 07 Juli 2011 8:49 To: [email protected] Subject: [belajar-excel] Hasil Lookup meleset Dear excellers, Satu lagi tentang lookup, sederhana sekali. Tapi lupa solusinya. No Bulan 1 January 2 February 3 March 4 April 6 June 7 July 8 August 9 September 10 October 11 November 12 December No Hasil Lookup 5 April Bagaimana formula / solusinya agar terdeteksi kesalahan bahwa data yang dicari tidak ada dan bukan memberikan nilai terdekat semacam itu? Salam Agung W.
<<image001.jpg>>
<<image002.jpg>>
