vlookp

  1. H

    Search product price by latest date

    Hi everyone! I am new here in the forum and I looked for some solution to my problem and I did not find anything similar, so I decided to create a new post. I have a workbook with two worksheets "STOCK" and "SALES REGISTRATION". In Stock, I give all of my products that I buy to sell...
  2. K

    Need Vloopkup Formula for Multiple Creteria + nested cells + multiply x between 2 dates

    Hi Trying to create formula foe the below table which has multiple criteria x Qty x Duration (with two dates) Attached sample file: Eg for Apple. Same as vlookup to be made for all items like carrot, beans, tv from nested cells. After this, the results will be converted to Pivot table /...
  3. I

    Summary Report

    Hi, I have a multi sheets tab in a workbook as you can see the name of sheets . i want when i click on the sheet name of any one the data show me of that sheet . than i can sort out by Last name as showing " Braaf "... Many Thanks A Column <tbody> Sheets Name HV-Agewell beg...
  4. J

    Finding 1st, 2nd, 3rd... Nth value by excel formula (vlookup/if/macth..)

    Hi there, I just wanted to fix the following problem that last few days struck my work. Data: <tbody> A B C D E F G H I J K 1 10/5/2016 RAM 10/5/2016 RAM RAHIM SUJA 0 0 0 0 2 10/5/2016 RAHIM 10/6/2016 RAM RAHIM SUJA SANGEETHA 0 0 0 3 10/5/2016 SUJA 10/10/2016 RAM RAHIM SUJA...
  5. F

    Array not calculating in Mac

    I created an array formula in PC excel 2010, but a MAC user is not able to see the results of the formula. see below for the MAC's screenshot. https://dl.dropboxusercontent.com/u/52990313/Array%20Image.TIF cell D2 is blank when there should be a result from the formula. auto calc in MAC...
  6. G

    VLOOKUP from 2 values rather than 1?

    Hi, I need to find out how to do this for work and I've been trying various things for the last 45 minutes to no avail. :( In this small example, I have a data table and a separate lookup table beside it. I want the lookup table to return values from the data table. The last columns value (G...

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