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.88/10.00
841 Point
#156 dari 99,935
Rated Worker: 10.00/10.00

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

Accepted Worker

elriyadh
Kab. Tangerang
    
9.75/10.00
365 Point
#322 dari 99,935
Rated Owner: 10.00/10.00

Owner sangat responsif

Makasih atas project

  User Bids

WahyudiWidodo
    
9.63/10.00

Iswanto
    
9.55/10.00

miftahulkhoir72
    
10.00/10.00

elriyadh
    
9.75/10.00

naga92
    
8.88/10.00

yudhaarli
    
9.33/10.00

anlichandra
    
9.44/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

1,579 points
13 projects
    
10.00/10.00

appzone

3,578 points
18 projects
    
9.84/10.00

derodevil

1,524 points
10 projects
    
9.45/10.00

Iswanto

10,093 points
192 projects
    
9.55/10.00

lexdorf17

16,550 points
58 projects
    
9.76/10.00

Recommended Services

Open Projects

Dicari frelancer yang ahli membuat Aplikasi desktop

Open to SuggestionsOwner: kangarif
Deadline: 12 days

Butuh Aplikasi Desktop untuk Mencetak Label

Rp 1,000,000Owner: hotbiz
Deadline: 7 days

Butuh yg bisa edit wordpress dan plugin

Open to SuggestionsOwner: hadi11
Deadline: 1 days

Membuat sample radar chart Power Builder 11.5

Open to SuggestionsOwner: buepep
Deadline: 7 days

Buat Software Pembuatan Jadwal

Open to SuggestionsOwner: duniasantri
Deadline: 7 days