hlookup

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...

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...

**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...

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 =...

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...

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...

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">...

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)...

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...

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...

I have an excel database of survey information, and I want to determine the top questions with the lowest results, but return the actual Question in text format, rather than the value. I'm using the Small/Large formula to determine the numbers, but can't figure out how to match it with the...

Hello Everyone, I have what I think is a fairly easy problem that I hope I can get some help with. What I would like to do is have a formula that will help me mark if an individual (distributed by rows [i.e. the names in the table below) have achieved a certain variable (distributed in...

Apologies in advance for my PQ ignorance as I'm fairly new to its use. I do, however, feel I've combed the internet in search for an answer to my question, have not found it, and, thus, have landed here :) 1) I "Power Query" a local unedited excel corporate-provided report and begin my edits...

I am trying to have excel find the largest "Cost" value in a given range that is lower than a specified Cost value. I then need it to display its corresponding "Ton" value. Problem is that i need it to look the value up in reverse order, in order o have it select the absolute lares value in the...

Hi, For last couple of days, I am trying to solve this problem but didn't find out proper solution of this problem. could anybody please suggest me in which way I can resolve it ? here is my problem : in sheet 1, I have area, territory, brand wise daily sales data for the next year. in the 2nd...

I'm trying to look up rates based off of weight and miles. <tbody> Weight Miles 500 1000 1500 2000 250 4.5 6.5 8.5 10.5 500 7.5 9.5 11.5 13.5 750 12.5 14.5 16.5 18.5 </tbody> I have a cell where I type in the weight and another cell where I type in the miles. I want the 3rd...

Hi! I am trying to automate a scoring process. I have a team lineup with positions and scores for each player. I need to determine the top 3 scores for the positions D and M, the top score for G and F, and finally, the top 3 remaining scores. I need 5 total scores (Goalkeeper, Defense...

Hi, Hope some one can assist me with this. I am trying to do a HLOOKUP from data like below <tbody> 13/14 P13W3 13/14 P13W4 14/15 P1W1 14/15 P1W2 Bread 46 55 54 33 Rolls 28 22 42 12 Butter 66 57 58 69 </tbody> On another tab I have a drop down box to select the period/week...

Hello everyone, I am in sheet 2 A2. I would like to search a row (10) from sheet 1 to match sheet 2 A1. If i have a match, I would like to search the row below (11) from the reference cell (i.e. AG10) for the next column encountered that contains a 5. When i encounter a 5 in the column i...

Hello and thank you whomever is taking time to read this post. I really appreciate it. :) I have been tasked with helping my boss get a comprehensive excel doc together that saves a lot of time. In doing this, I have made enormous progress, but i've hit a snag. In a perfect world, I want to...