two way look up

  1. A

    Determine order number based on multiple variables

    Quick back story: I need to report shipping dates to customers. I gather this information by doing a two way index match on the customers PO number and the customers PO line number against our line number. When entering items into our system the Import Team is supposed create an order number...
  2. M

    Two way vertical and horizontal lookup including a date match

    I want a formula to lookup a date, establish whats it falls onto using the week ending date, match that against the employee name and return the intersecting value. For example, I want to see James' potential hours for 8/1/21, which should return 32 (B16). If the date was 04/04/21 then it...
  3. T

    Two way lookup - Text and Number

    Hi I'm trying to write a formula to solve for the below, where the Item and Quota are given and the multiplier is needed. Tried doing a sumifs with True lookup back can't get it to work. Any help is greatly appreciated. <tbody> <tbody> Item Quota Multiplier1 Multiplier2 Multiplier3...
  4. S

    Two way lookup with smallest reference value

    My current table form is <colgroup><col width="69" style="width: 52pt; mso-width-source: userset; mso-width-alt: 2523;"> <col width="50" style="width: 38pt; mso-width-source: userset; mso-width-alt: 1828;"> <col width="150" style="width: 113pt; mso-width-source: userset; mso-width-alt...
  5. A

    Lookup problem

    I want my formula to look up two values in two different columns. Refer to the attached link http://www.box.net/shared/yed7167g9z The blank columns in sheet 2 with headins in red are the ones needed to be filled by the formula which first looks up the family no. and then the family member...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top