bikin searching function dengan vlookup

 

dear gan, saya membutuhkan orang yg bisa membantu saya untuk merevisi seraching data function dengan vlookup method, jadi ada 2 sheet, pertama sheet sumber data ada list2 barang, kedua sheet penjualan, jadi input data penjualan dari sumber data, waktu diketik ada autocomplete text. silahkan di bid

thanks

Microsoft Excel

Project Class: Open to Suggestions
Published Budget: Open to Suggestions
Finish Days: 1
Published Date: 29/11/2016 13:28:09 WIB
Start Date: 29/11/2016 17:21:18 WIB
Project Status: Closed
Accepted Worker: Adi (elriyadh)
Accepted Budget: Rp 50,000
Project Ending: Completed
Finish Date: 30/11/2016 14:13:27 WIB

Project Owner

jackss
    
9.67/10.00
1,079 Point
#168 dari 122,033
Rated Worker: 10.00/10.00

kerjaan cepat dan bagus!! thanks bantuannya!! good worker

Accepted Worker

elriyadh
Kab. Tangerang
    
9.86/10.00
697 Point
#221 dari 122,033
Rated Owner: 10.00/10.00

Owner sangat responsif

Makasih atas project

  User Bids

WahyudiWidodo
    
9.63/10.00

Iswanto
    
9.62/10.00

miftahulkhoir72
    
10.00/10.00

anlichandra
    
9.56/10.00

elriyadh
    
9.86/10.00

naga92
    
8.88/10.00

yudhaarli
    
9.33/10.00

pipittmatsuyama
    
7.00/10.00

PCiptaL
    
0.00/10.00

andriaircomp
    
0.00/10.00

Setyatrias
    
0.00/10.00

ennomy
    
0.00/10.00

radensaputra
    
0.00/10.00

roemly
    
0.00/10.00

melisya
    
0.00/10.00

Heri1085
    
0.00/10.00

Recommended Workers

1v4nWorld

2,389 points
17 projects
    
9.88/10.00

adiet88

2,554 points
2 projects
    
8.67/10.00

Iswanto

12,326 points
249 projects
    
9.62/10.00

appzone

3,798 points
25 projects
    
9.85/10.00

triuntoro

3,347 points
16 projects
    
9.93/10.00

Recommended Services

Open Projects

Aplikasi Kasir Sederhana

Rp 1,500,000Owner: dekahandayani
Deadline: 10 days

Pembuatan Aplikasi Keuangan Koperasi

Open to SuggestionsOwner: didikahm1768
Deadline: 20 days

Telegram Chat Scrapping Auto Forwarding

Rp 3,000,000Owner: kiriko
Deadline: 7 days

Sistem Tiketing Pesawat & Kapal Laut

Open to SuggestionsOwner: pramonoutomo
Deadline: 60 days

Membutuhkan jasa pembuatan program Matlab

Open to SuggestionsOwner: Rapathad
Deadline: 10 days