hlookup

I've been searching google and through trial/error trying to figure out how to accomplish the following and not having much luck. A little bit of background on the file I'm trying to create. Each worksheet of the workbook will be used to collect data about specific individuals in a particular...

Hello I'm new here. My name is Leo. I have a database of keywords in diffrent tabs and would like to know if there is a way to pull information out of this tabs and display it. i.e. I would like all the rows that contain the word "fish" in all the tabs to display on "this tab" I have been...

Hi all, I have a summary sheet and about 250 different worksheets, and in column C of the summary page I have the name of each tab in the workbook. I would like to do a lookup to the particular worksheet, and once there, find the word "total" in Row 8 (will be found no later than column N, but...

Hi guys, I've been working on someone else's spreadsheet just for setting up pivots and data displays. However, I realised it wasn't calculating the right numbers in all cases...and I've realised it's because they use an HLOOKUP and the whole left hand side only thing is affecting it. It's...

So i may have over complicated this but hope someone can help me from pulling the rest of my hair out. So i have 2 sheets one has information that is in rows and the other that i am wanting to have the formula return the value in horizontal format. Sheet 1 has columns Switch/Port/Patch...

Hi, I have a summary table similar to the one below. The worksheet has column headers with multiple criteria consolidating into the single row criteria. <tbody> FCST Actual October October 2017 2017 Account 1 Account 2 Account 3 Account 4 </tbody> The data is located...

Hi there Excel Questions helpers! I've got myself confused and stuck. Below is a link to the spreadsheet where we need these 3 actions to work: Data tab - When #nights has a value in it (any value that is not null), then all cells must highlight (so from B to O). I can get 1 cell to highlight...

Looking for help to build a formula to return data in rows if one of it's cells contain an amount between two certain numbers. I think I need an HLookup on data on the first worksheet with an If statement if values are between $250-$500 for example. Easy enough?

Hi there, Is it possible to combine the sumbycolor function and hlookup? Here is my data file - https://ibb.co/gkdMYw Summary sheet - https://ibb.co/h3tG0b I'm trying to dynamically calculate the sum for a given month/project/team. So in cell C4 I'd like to calculate the total for Team B...

I have a situation with a table that I am using a hlookup. The problem is the lookup value might not be in the table and I will need to interpolate for the value that is not in the table. Below is a copy of the table 10,000 15,000 25,000 50,000 75,000 100,000 150,000 250,000 500,000...

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

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

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

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

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

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

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

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

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

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