Đã Đóng

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

Kỹ năng: Excel, Microsoft

Xem thêm: 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

Về Bên Thuê:
( 0 nhận xét ) Auckland, New Zealand

Mã Dự Án: #1021468

57 freelancer đang chào giá trung bình $47 cho công việc này

svet63

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

$80 USD trong 1 ngày
(60 Đánh Giá)
6.6
bharanisrihari

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

$50 USD trong 2 ngày
(67 Đánh Giá)
6.4
vserv

Pls see your messages. Thanks

$30 USD trong 1 ngày
(65 Đánh Giá)
5.8
koolsidz

Please see PMB

$55 USD trong 0 ngày
(109 Đánh Giá)
5.8
nagybatonyi

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

$40 USD trong 1 ngày
(51 Đánh Giá)
5.7
dev3dworx

Please check PMB for details.

$150 USD trong 3 ngày
(19 Đánh Giá)
4.7
DrTech76

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

$30 USD trong 0 ngày
(23 Đánh Giá)
4.6
kulhanekd

I would like to bid. Thanks Donna

$50 USD trong 1 ngày
(10 Đánh Giá)
4.5
carmenli

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

$30 USD trong 0 ngày
(20 Đánh Giá)
4.3
muthumuni

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

$30 USD trong 0 ngày
(7 Đánh Giá)
3.8
muhmuuh

Hello! Please check PM for details. Thanks

$30 USD trong 1 ngày
(8 Đánh Giá)
3.6
curver

Hello, please check my message. Thanks

$45 USD trong 0 ngày
(3 Đánh Giá)
3.4
smartgest

I can help you with this. Please check PM.

$30 USD trong 0 ngày
(1 Đánh Giá)
3.2
cdumitru

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

$30 USD trong 1 ngày
(5 Đánh Giá)
3.2
rajkavikumar

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

$30 USD trong 0 ngày
(3 Đánh Giá)
3.1
sjestuista

please check pmb for details

$30 USD trong 0 ngày
(3 Đánh Giá)
3.1
ahbjee

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

$35 USD trong 0 ngày
(3 Đánh Giá)
2.4
jaimetravail

please see PM

$30 USD trong 0 ngày
(2 Đánh Giá)
1.6
kanadyanako

Kindly read my PM

$30 USD trong 0 ngày
(1 Đánh Giá)
1.8
saranga86

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

$30 USD trong 0 ngày
(1 Đánh Giá)
1.2