# hlookup

1. ### HLookup Unexpected Value

I am doing a simple Hlookup with dates at the top of my array. My lookup compares dates but looks at only the month and year then compares only the month and year of the dates at the top of my table. Then I am returning the 3rd row of my 3 row table. Here is my formula...
2. ### Identify Value Farthest to Right

Hi Everyone, I am trying to figure out a way to get the latest date a which a customer has canceled a subscription. (Our customers come on and off fairly often.) Here's an example of what the data set looks like: <tbody> Account July-16 Aug-16 Sep-16 Oct-16 Nov-16 Dec-16 Jan-17 Feb-17 Mar-17...
3. ### Hlookup for max value

Hello all, I have a range of data as table below and looking for the max cost for each item. Wondering how can I use HLOOKUP to get the max cost. Thanks for advance! <colgroup><col width="64" span="7" style="width:48pt"> </colgroup><tbody> Item A Item B Item C Item A Item D...
4. ### Matching a vertical data set with a horizontal set

Hello, I need to fill in a table by matching the vertical number in Column J with the horizontal number in Row 3 and then entering a 1 if they match or blank if they do not match. I've added a 1 at the intersection of N4 because both the vertical and horizontal numbers are 31494. Table looks...
5. ### Matching a vertical data set with a horizontal set

Hello, I need to fill in a table by matching the vertical number in Column J with the horizontal number in Row 3 and then entering a 1 if they match or blank if they do not match. I've added a 1 at the intersection of N4 because both the vertical and horizontal numbers are 31494. Table looks...
6. ### Index, Match Help

hello, I'm struggling coming up with a formula to give me a value with 2 given starting conditions. I will paste my table in here after I explain it. So, the top row of data is a given number but not exact, and the various rows of numbers below the top row is also given, but not exact. The top...
7. ### Index/Match OR VLOOKUP/AVERAGEIF/HLOOKUP to return values

Hello Everyone, I have two sheets: Sheet1 and Sheet2. Sheet1, contains the raw data. Sheet2, contains tables with formulas to pull from Sheet1 <tbody> A B C D E F G H I J K L M N O 1 Day of Week Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sunday...
8. ### SumIf like formula for horizontal data where your value has to search within a text string

Hi, I hope somebody is able to help with the below. I've been given a report with a bunch of horizontal data (changing the entire report structure is not really an option at this point). In the column where it says "Language 1" I need a formula that can search the first row of all the columns...
9. ### VLOOKUP inside SUMPRODUCT

I have been unable to come up with a solution for a complex Excel formula. I have a table for which I use SUMPRODUCT to multiply 2 columns in an array. However, I want to have the formula look at another column in the array, and based on that number do a HLOOKUP to another table, and them...
10. ### vlookup & more....

I have a file (link below) that i need serious help with. I have employees putting data into a given sheet (T#1)[34 in ttl], then into a given sub form (Street). Now I'm not sure how best to facilitate this but here are the problems that I need help with. 1) eg. make the data (once complete)...
11. ### Odd INDEX/MATCH

I am having a bit of trouble trying to determine this index and match. My end goal is to automate this through VBA, but I will settle for just the formula. I am trying to INDEX the titles based on the subcodes. I have thought of doing a MATCH/LEN combination, or a HLOOKUP, LOOKUP and have tried...
12. ### If statement with conditions

Hello, I'm trying to do an IF statement formula but I have too many arguments. My goal is to assign a numeric value in cell C3 based on conditions met or not met in C2 and C1. For example, as shown if table below --- if income is between \$24,600 - \$49,200 and the family size is 4 or fewer...
13. ### Lookup multiple values in a single cell (separated by commas) and then return the values to a single cell

**XCEL FILE ATTACHED** Question: If I have a workbook with 2 tables; 1 has the data that I want to search and 1 is empty and where I would like the "searched" values output, what lookup formula would I need to use?. The attached file is a list of companies in one column and the states in which...
14. ### Need Help With Lookuop but not sure what kind of Lookup

Thank you in advance for your help. I'm working with two separate excel sheets. In the first sheet the data is laid out as depicted in the first table below (Table1). My second sheet is laid out as the second table (Table2) In Table1, Task2 Site2 = D5, Task1 Site3 = D3, Task3 Site1 =...
15. ### Hlookup from a pivot I made - Second look up results in N/A

Hi, I created a pivot table with two row labels. I want to look up the first string of row labels and there after only the first 5 of the second string of data. I manage to to a Hlookup and got all my results but when I move on to the next row label I get N/A. See below example: Pivot created...
16. ### Possible SUMPRODUCT & HLOOKUP?

Hello and thanks in advance for any help! I have a table below; I then have 3 input cells; Country, City and Grade (the list is essentially 2K rows) so if input cell 'Country' is USA and they select 'NYC' for next input cell...and select 'Grade K B' for the third cell, I need a return of the...
17. ### How To Return Multiple Match Values in Excel Using Hlookup and INDEX Match

Hey everyone. I am trying to figure out how to write an Hlookup up formula that shows multiple results. I want my Hlookup to return multiple value horizontally instead of vertically. Please see below as an example: Criteria: <tbody> <colgroup><col width="64" style="width:48pt">...
18. ### HLOOKUP with multiple criteria

Good Afternoon all, I have been searching the forum as well as other sites as to how I can resolve a little problem I have I have a table in a cross tab format, something like this (a) ---------------------(b) -----------------(c) ---------------(d) ---------------(e)...
19. ### Help with lookup

Hi, I have the following data. I select level and give the flags as Y or N. if I select level 1 and flag as N, it should show the points related to that level in points column for each activity else it should show the points related to next level in points column. Following is the data I have...
20. ### Hlookup against Dropdown list.

Hi, I am trying to do a Hlookup to return the value from a specific date for a specific person. Attached is a sample of the file. The date in cell A1 is a drop down list based on the date range from the second worksheet. I am trying to link cell g3 to corresponding value for the date in A1...

### This Week's Hot Topics

• VBA (Userform)
Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
• List box that changes fill color
Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
• Remove duplicates and retain one. Cross-linked cases
Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
• VBA Copy and Paste With Duplicates
Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
• Macro
is it possible for a macro to run if the active cell value is different to the value above it
• IF DATE and TIME
I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...