Fermé

Microsoft Excel - vlookup quations or something similar

Basically I need a tool to aid in quoting jobs.

I have a table (simplified version attached) that has been populated behind the scenes and gives different quote prices based on two critea - the amount of colours used in the job (Columns) and the quantity of units ordered as there are different price breaks the more units ordered.

What I need is a separate spreadsheet that references this table. I want to be able to simply add in the known critea of a job in two separate cells i.e Quantity customer is ordering, let's say 150 units and how many colours the job is let's say 1.

In this example I would like the equation to reference the table - understand that 150 units falls between the range 150 - 249 and hence uses row 9 and that it is just one colour hence it reference column D the answer then being cell D9 or $23.60

Thanks

Dave

Compétences : Excel, Microsoft

Voir plus : microsoft jobs, microsoft excel spreadsheet, microsoft excel job, jobs microsoft excel, job quote example, job aid example, how to quote jobs, column jobs, microsoft vlookup job aid, vlookup table, simply jobs, microsoft excel price, how to microsoft excel, excel uses, Vlookup, spreadsheet microsoft excel, price excel, excel vlookup, excel table, excel spreadsheet job quote, excel based, excel add-in, excel add in, excel colour, excel row column

Concernant l'employeur :
( 0 commentaires ) Auckland, New Zealand

N° du projet : #1021468

57 freelance font une offre moyenne de $47 pour ce travail

svet63

Excel developer since 1997. Can do. Regards, Svet.

80 $ USD en 1 jour
(60 Commentaires)
6.6
bharanisrihari

Hello, Excel VBA / Macro expert here. Please check PM for details. Thanks!

50 $ USD en 2 jours
(67 Commentaires)
6.4
vserv

Pls see your messages. Thanks

30 $ USD en 1 jour
(65 Commentaires)
5.8
koolsidz

Please see PMB

55 $ USD en 0 jours
(109 Commentaires)
5.8
nagybatonyi

Such jobs are my daily practice, please see PMB for details! Regards!

40 $ USD en 1 jour
(51 Commentaires)
5.7
dev3dworx

Please check PMB for details.

150 $ USD en 3 jours
(19 Commentaires)
4.7
DrTech76

Hi! You can have it in under one day, including the necessary testing. Kind Regards, DrTech76

30 $ USD en 0 jours
(23 Commentaires)
4.6
kulhanekd

I would like to bid. Thanks Donna

50 $ USD en 1 jour
(10 Commentaires)
4.5
carmenli

Hello. Please refer PM for sample and details. Thank you.

30 $ USD en 0 jours
(20 Commentaires)
4.3
muthumuni

Dear sir I can do it for you just right now, So kindly see my message thank you

30 $ USD en 0 jours
(7 Commentaires)
3.8
muhmuuh

Hello! Please check PM for details. Thanks

30 $ USD en 1 jour
(8 Commentaires)
3.6
curver

Hello, please check my message. Thanks

45 $ USD en 0 jours
(3 Commentaires)
3.4
smartgest

I can help you with this. Please check PM.

30 $ USD en 0 jours
(1 Commentaire)
3.2
cdumitru

Hello, I would like to do this task. Please see PMB for a draft solution. Regards

30 $ USD en 1 jour
(5 Commentaires)
3.2
rajkavikumar

Hello , I have created what you said please heck the PMB

30 $ USD en 0 jours
(3 Commentaires)
3.1
sjestuista

please check pmb for details

30 $ USD en 0 jours
(3 Commentaires)
3.1
ahbjee

Hello Sir, i m ready to start work ASAP please.

35 $ USD en 0 jours
(3 Commentaires)
2.4
jaimetravail

please see PM

30 $ USD en 0 jours
(2 Commentaires)
1.6
kanadyanako

Kindly read my PM

30 $ USD en 0 jours
(1 Commentaire)
1.8
saranga86

Dear Friend. I have finished your job. please see the PM.

30 $ USD en 0 jours
(1 Commentaire)
1.2