Need an Index, Match, Look Up formula
- or -
Post a project like this2724
$$
- Posted:
- Proposals: 5
- Remote
- #1337786
- Awarded
Description
Experience Level: Intermediate
I need a formula to look up a specific client rate.
In my workbook I have multiple sheets. The 2 that are important for this are: Order Entry! and Rates!.
On my sheet Order Entry! I will input - client tariff name (cell D3) and transport mileage (cell B42). I need the rate for this mileage (cell B42) under the client tariff (Cell D3)
On my sheet Rates! I have all of the client tariffs laid out. The client tariff names are listed in Column A:A. To the right of column A I have 2 columns of mileage (columns B and C) example: cell B2 = 1 and cell C = 50, cell B3 = 51 and cell C3 = 100....
In column D is listed the tariff for the mileage range in B:C. For example if if the mileage were 40 miles, I would look for the matching client tariff name in column A, then scroll across to find the corresponding mileage tier, which in this case is 1 to 50 (B2 and C2). In the adjacent column and cell (D2) is the rate $200.00.
This is the value I am looking for ($200.00) and needs to be placed in Order Entry! Cell B32.
Help! Please!
In my workbook I have multiple sheets. The 2 that are important for this are: Order Entry! and Rates!.
On my sheet Order Entry! I will input - client tariff name (cell D3) and transport mileage (cell B42). I need the rate for this mileage (cell B42) under the client tariff (Cell D3)
On my sheet Rates! I have all of the client tariffs laid out. The client tariff names are listed in Column A:A. To the right of column A I have 2 columns of mileage (columns B and C) example: cell B2 = 1 and cell C = 50, cell B3 = 51 and cell C3 = 100....
In column D is listed the tariff for the mileage range in B:C. For example if if the mileage were 40 miles, I would look for the matching client tariff name in column A, then scroll across to find the corresponding mileage tier, which in this case is 1 to 50 (B2 and C2). In the adjacent column and cell (D2) is the rate $200.00.
This is the value I am looking for ($200.00) and needs to be placed in Order Entry! Cell B32.
Help! Please!
Deron B.
100% (1)Projects Completed
5
Freelancers worked with
5
Projects awarded
60%
Last project
22 Mar 2017
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies