vlookup & max

  1. L

    Vlookup based on conditional match

    Hi, have a spreadsheet with list of book titles in column c and page counts in column E. Looking for vlookup formula that returns the title of the longest book - Thanks for your help.
  2. G

    Vlookup and MAX not working.

    Hi, I am working with a pivot table and attempting to extract the highest value (count) found and returning a user name based on that. I am getting the dreaded N/A as a result of my formula. I am running Excel 2010. Here is the test case I have. <tbody> A B Bob 1 Fred 2 Bill 3 Sam 4...
  3. J

    Excel Check Vlookup value if cell value matches

    I have two Sheets "DATA" "RAW DATA" In DATA sheets Column A COLUMN B APPLE 10 APPLE 15 APPLE 16.5 BANANA 35 BANANA 20 BANANA 36 ORANGE 45 ORANGE 15 ORANGE 50 In RAW DATA sheet in Column B I have to input...
  4. D

    Max Look Up with Multiple Criteria

    I have a time sheet Table that I pull from Share point and it's linked. to fill the table I have 4 criteria that must be met .Any formula I use It gives me zero result and don't show me the actual Time in the time sheet. Can you help me? Employee Name Sales Manager ClockType Date...
  5. S

    Vlookup max value

    I am having difficulty trying to get the max closing reading from this table. I can get the min value using =MIN(VLOOKUP(E2,A2:B10,2,FALSE)) it brings up the 1st entry no problem. But I tried the same formula with =MAX(VLOOKUP,E2,A2:B10,3,FALSE)) but it brings up the closing reading for the 1st...
  6. N

    Vlookup for max value without using an array

    <colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> a 2 g 4 q 6 f 7 a 4 t 6 </tbody> From the data set above I would want to vlookup for "a" and return the value 4 instead of 2. I believe this post is a good starting point...
  7. M

    MAX function with mutiple and identical hits

    Hi all - thanks for a great site. I have an unresolved issue using MAX function that has multiple and identical hits. If anyone has a tip or formula for my issue I am grateful. My data (two columns) <tbody> Customer ID Customer age 1 66 1 65 1 66 2 27 3 58 3 62 </tbody>...
  8. D

    Selecting The Max value with VLOOKUP

    Good day all, I'm having difficulty selecting the Max value using VLOOKUP: eg. <tbody> A B 200 50 g 300 100 g 323 150 g 346 200 g 369 300 g 392 300 g 550 350 g 425 400 g 33 450 g 2 500 g </tbody> I want to get the value in column "B", for the max value in column "A". I...

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