-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.
vlookp
-
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...- hpernaf
- Thread
- Replies: 7
- Forum: Excel Questions
-
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 /...- kumar46
- Thread
- Replies: 1
- Forum: Excel Questions
-
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...- imran ashraf
- Thread
- Replies: 0
- Forum: Excel Questions
-
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...- jgopalk
- Thread
- Replies: 5
- Forum: Excel Questions
-
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...- fasullo
- Thread
- Replies: 0
- Forum: Excel Questions
-
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...- gohan2091
- Thread
- Replies: 10
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
change colour of picture based on cell value
- Replies: 46
hello again guys I have found this video of Bills that explains how I could dynamically change the .width & .Height of a shape in excel, but I am... -
VBA - Combine Multiple workbooks into 1 worksheet
- Replies: 45
Hi, I am trying to write a VBA script which will combine multiple workbooks into 1 worksheet, copy and pasting all columns as values. Each sheet... -
Last Display on userform to a Listbox
- Replies: 35
[CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am... -
Vlookup and hlookup combination
- Replies: 28
Hello forum friends, I am using Excel 2016, XLOOKUP is not an option for me (I think). I have a worksheet that is linked to a website where the... -
Code giving run-time error when called, but not when placed on worksheet.
- Replies: 23
The code listed below runs on the worksheet, but gives a [B]Run-time error '424': Object required[/B] when called. I called the code, because when... -
Help with Current and highest streaks
- Replies: 23
Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...