Em Andamento

Match Part Number to Price in Excel

I have two excel files one contains a list of car parts their part numbers, description but no prices and the other contains part number, price and description and in both files separated in their columns.

What I would like to achieve is to be able to merge and organise both spreadsheets so that the one without prices incorporates all the prices from the other sheet. I've been told I can use Vlookup, IF and ISNA functions to achieve this but I don't know how. And the descriptions all match up via concatenation and the spreadsheet ready to be uploaded to my store tab or comma delimited.

I need this done urgently please. I will send you the files if required. There are quite a few products in them. Happy bidding!

Habilidades: Processamento de Dados

Ver mais: match part number excel, number price excel, excel part number price, excel match part number, price match part excel, will price, match list, use data entry excel, match part number prices, price part number excel, match parts numbers excel, match number excel, excel part matches, match part number string, car part number matching, part number creator excel, part number system excel, parts number match, n excel, price excel, part, need part, match, excel vlookup, entry number

Acerca do Empregador:
( 25 comentários ) London, United Kingdom

ID do Projeto: #135715

Premiar a:

whtfury

Please see by PM. Thank you!

$30 USD em 1 dia
(2 Avaliações)
2.5

44 freelancers estão ofertando em média $37 para este trabalho

arvindtechno

Hello, We are expert in EXCEL. Ready to take up the job ASAP. Pls check PMB for more details. Thanks

$30 USD em 1 dia
(119 Comentários)
6.9
ggopi

I'm Gopi from India. Please check my PMB.

$30 USD in 2 dias
(205 Comentários)
6.5
garbar

i can do it.

$30 USD in 0 dias
(66 Comentários)
6.1
SouthIndian

Plz. refer PMB. Tks.

$30 USD em 1 dia
(126 Comentários)
5.7
iasmumbai

Hi, I’m keen to take up your work. For further details about me as well as my experience is being conveyed in PMB. I trust that the said information will be helpful in deciding my merit for awarding the work. Thankin Mais

$30 USD in 2 dias
(118 Comentários)
5.5
Supersonic

PLZ CHECK PMB THANKS

$30 USD in 0 dias
(4 Comentários)
4.8
teamspirit01

Hi. This is basic stuff. Please check PMB for a proposal.

$75 USD em 1 dia
(11 Comentários)
4.5
crayons

hello, plz chk pmb for details. Crayons

$65 USD em 1 dia
(1 Comentário)
3.4
AncaU

Hi! Please read PM

$30 USD in 2 dias
(13 Comentários)
3.4
A1Experts

Hi can do it

$30 USD in 0 dias
(5 Comentários)
2.5
AUKBASEDPROBLEM

Hi I can get this done for you within 1 hour. I am uk based and ready. Many Thanks

$30 USD in 0 dias
(1 Comentário)
2.4
ripsoft

Hi, Pls check PM for more details. Regards, Munaf

$30 USD em 1 dia
(2 Comentários)
2.2
varunbjp

HELLO SIR, WE'LL FINISH IT WITHIN A DAY, LETS START THE WORK, THANKING U WITH KIND REGARDS, MISTINA THOMSON, FOR TECHINDIA

$55 USD em 1 dia
(2 Comentários)
2.1
sureshnadhamuni

Kindly check PM for additional information:)

$30 USD em 1 dia
(2 Comentários)
2.1
vosmerkin

Please check PMB

$30 USD em 1 dia
(1 Comentário)
1.9
sangrampp

Dear Sir, Please check the PMB. I have left my details there. Thank you.

$30 USD em 1 dia
(1 Comentário)
1.0
sunnybabita

Basically we have been running an Institute which provides data processing , data entry services and other services. We are agree to undertake job of your company as per laid down terms and conditions on the bid posted Mais

$30 USD in 5 dias
(0 Comentários)
0.0
qualityprof101

Please see my PM

$50 USD in 0 dias
(0 Comentários)
0.0
abhishek414

I Can do it for you, if you give me a chance. Thanks

$30 USD in 2 dias
(0 Comentários)
0.0
anilrana579in

Hi, I can do this in 1 hour. I am an MIS person employed with a call center. Thanks and regards, Anil Rana

$30 USD em 1 dia
(0 Comentários)
0.0