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.68/10.00
1,094 Point
#172 dari 131,113
Rated Worker: 10.00/10.00

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

Accepted Worker

elriyadh
Kab. Tangerang
    
9.77/10.00
748 Point
#230 dari 131,113
Rated Owner: 10.00/10.00

Owner sangat responsif

Makasih atas project

  User Bids

WahyudiWidodo
    
9.63/10.00

Iswanto
    
9.64/10.00

miftahulkhoir72
    
10.00/10.00

anlichandra
    
9.57/10.00

elriyadh
    
9.77/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

Iswanto

13,151 points
262 projects
    
9.64/10.00

1v4nWorld

2,389 points
17 projects
    
9.88/10.00

adiet88

2,554 points
2 projects
    
8.67/10.00

triuntoro

3,347 points
16 projects
    
9.93/10.00

bl4ck4nt

11,323 points
88 projects
    
9.31/10.00

Recommended Services

Open Projects

Saya butuh programmer yang bisa membuat service print POS Epson TM-U220

Open to SuggestionsOwner: william222
Deadline: 14 days

B*t lazada

Rp 5,000,000Owner: Yoshinua
Deadline: 7 days

3 PROJECT IN EXCEL

Open to SuggestionsOwner: kana88
Deadline: 1 days

Pembuatan Project Aplikasi Internal Perusahaan

Rp 6,000,000Owner: andolizm
Deadline: 7 days