array formula vlookup

  1. 4

    Lookup 2nd Occurrence of Value Starting From Bottom Row And Return Value In Different Column

    I'm looking for a formula that will look in Column A:A and match the 2nd occurrence starting from the bottom row and looking up, looking for a value located in C1. It will then need to return the value in the same row as the 2nd occurrence in Column B. For instance: Row/Column A B C 1 4 E...
  2. L

    #NUM! error in Array Formula - trying to use IFERROR to fix but not working

    Hi all can anyone help: Heres my original formula for an array lookup and its working fine but I get #NUM! errors when it cant find any more matches so I found a IFERROR formula modified it to fit mine but it doesnt work: where have I gone wrong - I am entering it as an array CTRL SHIFT ENTER...
  3. G

    Array formula lookup

    Hello, I got stuck on what seems like a pretty easy calculation. Any ideas why the formula below does not work? =LOOKUP(1,{0,0,0;0,1,0;1,0,0},{“R1C1”,” R1C2”, ” R1C3”; “R2C1”,” R2C2”, ” R2C3”; “R3C1”,” R3C2”, ” R3C3”}) Needed result: R2C2 Is there a different way to do this? In a very...
  4. C

    Return minimum in a table equaling 2 criteria

    I need to return the minimum quantity for a part number where the last purchase date is no greater than 2 years from today. The list of parts that will need to be looked up agains the below list will be on another tab. For example, if I needed to know the Min qty to take place in the last 2...
  5. M

    Commission based formula

    Hi, I need a formula which will analyze a reps total gross commissions and determine what percentage they are eligible for commission payouts: For example, a rep gets paid a percentage of their incoming commission based on YTD performance: 0 - 51999 is 50%, 52000 - 72999 is 52%, 73000 - 99999...
  6. M

    Any Array Formula gurus out there ?

    I am hoping someone knows array formulas better than I, to give me this solution. The formula I am trying to do has a Vlookup within an array. Here it is: {=AVERAGE(IF(C5:C13="A Finger",VLOOKUP(D5:D13,Rates,2,FALSE),FALSE))} In English: I want to find the average rate for the A Finger...

Watch MrExcel Video

This Week's Hot Topics

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
Top