hlookup

Dear all, I am trying to find a specific value (from multiple options) in an array (Please, see the picture below). I tried several formulas, playing with OR, HLOOKUP, INDEX and MATCH, but I couldn't find a working formula yet. It is all good if I look for a single value, but as soon as I add...

Hi, I have the results of a survey with 4,500 responses, the report groups respondents with similar characteristics in different columns as shown below. I'm looking for a way to retrieve all responses for each question in one column. I've tried Hlookup with CountA, but it's just not working...

Dear all, I am currently trying to return some data from a larger database. I have created a test sheet that is very similar to the real sheet that I am working with, for the sake of privacy and making things easier to understand from an outside perspective. Currently, I have the following...

Dear all, I am currently sitting with a rather large sheet of data. I have made a smaller, and more simple data sheet for simplicity's sake. Currently I have the following information: As you can see, the data for 2016 has already been filled out (through an old and more manual method)...

Hello, please please can someone help me: I have a simple forecasting sheet, where each month a payment is made, until the value reaches £0. The example below, shows two lots of £500 per month - however if the payments were to increase or decrease this would change the month were £0 is...

Let me start by saying I am a pretty newbie to Excel - I know the basics but V/H lookups are out of my capabilities. What I am looking to do: I have bike mile logs on two sheets and on a third are thee highest or max for a particular stat. I was able to create the max sheet but what i would...

I wanna show the level range beside the alphabet, but does not work if I use Hlookup as normal, like the picture.

need help to find the result as per below. can someone help me please. ABCDEFGLMNOP3NoEmployee NameP RatingCriticalityResultReference Table41MARCUS LIMD3CriticalityP Rating52ELIZABETH TAYLORC3DCBA63KEVIN COSTNERB31D1C1B 1A174LIM AH LIMA32D2C2B2A285ABDUL PATAHD23D3C3B3A396LEE KUAN YEWC2107NG...

I have a very simple excel sheet. I am going to break out sections and give them to different team members. No team members will have the same data. I need to match on Vendor number (Rows) and dates (columns) as shown below. The main sheet will be pulling the data from each of the other sheets...

I spent a day reading Excel Help articles and trying many different approaches to solving this, but have not been successful. If anyone can help me with the proper formula to make this happen, I would be most grateful. The goal is to identify which physical host (Hostname) a vm computer...

Hi, I have an hard time being able to figure out a solution to my issue and would like to see if anyone can help or has ideas of how this challenge can be resolved. I am trying to find a formula that is able to tell me if a cell has changed from a number to a text (horizontally) resulting in...

Hi My formula is =HLOOKUP($D48,Directorate!D$52:D$350,3,FALSE) As you are aware for this HLOOKUP formula to work the infofrom Cell D48 must be on the line D52 (in the table array source), to bring back the 3rdrow values. However I would like to drag this formula this down (as Ihave 600...

I'm trying to combine hlookup() and offset() to find the last value in a row, then go up 2 rows and left 1 cell. Each works independently, but when I try to combine them, errors occur. =OFFSET(M3,-2,-1) --- "M3" is the below hlookup() reference =HLOOKUP(9.99999999999999E+307,B3:Y3,1) Is...

Okay, this is probably something simple but I cannot figureit out. I have a single column of data – approximately 9,000 cells in length. Itfollows the same format. A person’s name followed by 3 values. Can I use alookup function that will return the same 3 values that follow each person’sname...

Hey guys Got a little trickier one. What I have is a weekly cash flow statement that I am attempting to project when we will receive cash payments on jobs invoiced. I have two tabs: the main CF tab and the invoice tab (see below). What I want to be able to do is for a given week, is to push out...

I have a problem that seems like it should have a simple solution. I'll use this example situation to explain. in the first table I have data validation drop-down lists in the first column to choose a category. In the second column i have an =INDIRECT drop-down list to get an Item out of that...

Hello all! It's my first post, so please be nice :-) I'm trying to create a "dashboard" which looks up a value (hlookup) in the top row of the data set and returns back a sum of its "scores" from the column to the right. I tried and failed at nesting hlookup, sumproduct, and wrapping them in an...

Hello, I am new to the forum as a registered user. Can you help me with a source code or something in vba? What I need is to gather data with HLOOKUP and comments from another workbook and put them altogether in another. I need this because the initial file is in the server and is being...

I have a data sheet like the below and i want to for each row find the corresponding X and put it into the the below. I'm not savy with VB and my work computer has Excel 2016. Thanks for the help. <colgroup><col style="width:48pt" width="64" span="6"> </colgroup><tbody>...

Hi Everyone, I'm trying to pull a Named Range using Vlookup into a Hlookup to return a text value. I've tested the individual parts and they work fine but when i put them together I get "#VALUE" as a result. The formula is: =HLOOKUP(E$1,(VLOOKUP($B2,'Emp Lists'!$B:$F,5,FALSE)),($D2+1),FALSE)...