Suoritettu

Excel Vlookup Situation

Should be simple project for Excel Junkies.

I have two spreadsheets. one spreadsheet has 4 columns, the older one has 5. I need to lookup part numbers in the first spreadsheet, find the corresponding part number in the second spreadsheet, and return the weight which is only in the second spreadsheet.

Spreadsheet 1:

Part prefix Part number Part number AN Description Currency Unit Price GPPS Weight in LBS

RM 80808801 RM 80808801 MIRROR USD PCE 92.83

RM 43920438 RM 43920438 GRILLE USD PCE 234.77

RM 14784060 RM 14784060 FLAT USD PCE 45.36

RM 95220919 RM 95220919 HOSE CLAMP USD PCE 2.29

Spreasheet 2:

Part prefix Part number Description GPPS Weight in LBS

VOE 11417933 GRAPPLE ARM 1598.6

VOE 11417932 GRAPPLE ARM 1589.7

SA 3328445 HEATER 5

VOE 17481105 CONVERSION KIT 255.8

VOE 17481108 CONVERSION KIT 0

VOE 17473398 CONVERSION KIT 0

Taidot: Excel, Tietojenkäsittely, Tiedonsyöttö, Visual Basic, Matematiikka

Näytä lisää: php mysql simple project database, simple project php, simple project schedule excel, simple project tracking excel workbook, create simple project excel, excel project management spreadsheets, make simple project excel, simple project management marketing excel template, excel simple project need, pdf excel simple project, simple project based employee timesheet excel, simple project tracker excel, simple project tracking template excel, free simple project timeline template excel

Tietoa työnantajasta:
( 22 arvostelua ) Gardner, United States

Projektin tunnus: #31591348

Myönnetty käyttäjälle:

rahulg5466

--------I CAN DO IT RIGHT AWAY-------- ⭐⭐EXPERT IN EXCEL⭐⭐ Dear client, I can help you with your project of data entry in excel, VBA, EXCEL MACROS, VB, building an excel file, excel dashboard, pivot tables, charts, v Lisää

$20 USD 1 päivässä
(2 Arvostelua)
0.8

7 freelanceria on tarjonnut keskimäärin $28 tähän työhön

(578 arvostelua)
8.2
(309 arvostelua)
7.1
(221 arvostelua)
6.7
(134 arvostelua)
6.1
hayteekeys

Hello. From your job description I have learned that the requirements you have asked for are possessed by me very well. I am a graduate of computer science. Also, I have several good records in this field as I have be Lisää

$20 USD 1 päivässä
(20 arvostelua)
4.9
torrikress2

Hi, How are you today? Thank you for posting this project, and I'm very happy to bid your project. I've read carefully your project details. I have a tons of experience in Excel, Excel VBA, Visual Basic, Data Processi Lisää

$50 USD 1 päivässä
(1 arvostelu)
1.0