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.73/10.00
963 Point
#148 dari 105,263
Rated Worker: 10.00/10.00

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

Accepted Worker

elriyadh
Kab. Tangerang
    
9.80/10.00
457 Point
#294 dari 105,263
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.80/10.00

naga92
    
8.88/10.00

yudhaarli
    
9.33/10.00

anlichandra
    
9.47/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,798 points
19 projects
    
9.85/10.00

triuntoro

2,439 points
11 projects
    
9.91/10.00

Iswanto

10,454 points
205 projects
    
9.55/10.00

lamazido

987 points
2 projects
    
10.00/10.00

Recommended Services

Open Projects

Pembuatan Software Aplikasi Point of Sales (POS) untuk Kasir

Open to SuggestionsOwner: agusbambang
Deadline: 20 days

Buat software Expert Advisor MT4

Open to SuggestionsOwner: crescendo
Deadline: 7 days

Butuh 1 project untuk contoh Coupling dan Cohession

Rp 200,000Owner: tita89
Deadline: 2 days

Algoritma untuk prediksi nilai

Open to SuggestionsOwner: febiya
Deadline: 5 days

Buat Aplikasi Dari Excel

Rp 2,500,000Owner: ssauri005
Deadline: 7 days