# hlookup

1. ### Hlookup #N/A ????

=HLOOKUP(C3,G2:K3,1,FALSE) This returns N/A and I do not understand it row 1 holds the information I want returned to me c3 holds a monetary value I want looked up between G and K The formula in c3 looks between G3 and K3 and returns the Min. What is wrong with this as it is not working...
2. ### vlookup (or hlookup) cell with reference rather than actual number

I am doing a vlookup on a cell range where the value I'm trying to lookup (a date) exists, but it's not an actual number in the cell...it's a reference to another cell with that value (somewhere completely different). So, I'm trying to vlookup(date(1/1/2011),A1:A12,2,false) to get the B column...

Ok, I have what should be a simple little query, that is driving me crazy. 2 Worksheets, one sheet has a list of phone numbers with dates, thats it 2 columns. This sheet only has 1 record per phone number, 100 in all. The second sheet has the same exact phone numbers on it, and dates as well...
4. ### Vlookup Question

Hi, I have a quick question surrounding vLookups and wondered if anyone can help. I need a vlookup that will tally the total of the lookup value from a seperate sheet. <a href="http://www.flickr.com/photos/67298551@N07/6169686262/" title="2011-09-21_1618 by digiteers, on Flickr"><img...
5. ### Hlookups in Excel 2010

Hello, Can you help me with an hlookup function in Excel where I need to dynamically change the location of lookup table ????? how do u do that????:confused:
6. ### Find value where x & y of a table meet.

Hi, me and a co-worker have been trying to figure this out for quite some time now. I have a table w/multiple values in it. A2 through A6 have temperature values in it. B1 through F1 have gravity amounts in it. Below my table in a cell A10 i want to input a value for a specific temperature and...
7. ### Offset and Large issue

Hello I have MS Excel 03 and I am trying to create some added value to one of my reports. I have a listing of offices in column A going down and to the right are product names and an amount. I would like to use the large formula to grab the top three products and use the offset formula to...
8. ### Averaging returns from Hlookup that include values and text

Hi I'm in the process of building a sheet for the guys at work. Part of the sheet requires me to take a range of cells, convert them using hlookup into either straight values or text and then average the resulting range. Doing this as a two step process fine, but nesting the text returns from...
9. ### Lookup by date

Excel idiot here :) I need help with a lookup that I'm sure it super easy... If I wanted to look up the current week's values for each of these Employees, what formula would I use? Excel WorkbookCD47by...
10. ### Vlookup/Hlookup Alternative

Is there an alternative function that performs/mimics the job done by Vlookup/hlookup? thanks for your help
11. ### Combining Data Chart Data

I have two different data sets that I need to combine. Not sure how to attach a file to my post so I will do my best to describe. These data pieces are on two separate worksheets in the same workbook. I need to consolidate by date & name the Inbound Call #, Outbound Call # and Count of orders...
12. ### Hlookup that gives heading as the answer

Hi, I have a set of data that has names down the left hand side and countries across the top. I can find the max number for each name easily enough but i want to find which country this appears in. Name USA UK Sweden John 5000, 60, 100 Dave 1001, 23, 1000 Thom 8000, 50, 27000 So in...
13. ### HLOOHUP assistance needed

I am trying to run a HLOOKUP function however can not get it to work. I am trying to identify a specific date which returns the smallest number in a range of numbers. I would like the HLOOKUP to identify a specific date where a business makes the biggest loss. So if I new that the biggest...
14. ### How to solve this problem? With nested ifs or vlookups?

****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 12">****** name="Originator" content="Microsoft Word 12"><link rel="File-List"...
15. ### Creating a unique report/page per user ID

I have and excel spreadsheet with two tabs: Tab 1) an array of data which has a unique ID per person and each person can have 1-20 rows of data. Tab 2) a one page report for which an end-user enters the unique ID and then the report will pre-populate with data from the data tab. I can't...
16. ### Quick help with sum of HLOOKUP

Hi, I have a master table with weights. And there is a row for which I need to do a sum of the associated weights. There would be some blank cells in between as well. Any help would be great. E.g. The sum of the below row should come out as 3. <TABLE style="WIDTH: 536pt; BORDER-COLLAPSE...
17. ### Help with HLOOKUP

I would appreciate some help with a HLOOKUP formula. <o:p> </o:p> My application contains a series of records that include a Base Price (can be anything) and coverage year (1 thru 6). I also have a table of uplifts and discounts per year (refTable). <o:p> </o:p> For each record, I...
18. ### HLookup / Top Ten listing Help

Hi Everyone, Question - I have a spreadsheet with say 50 rows and 50 columns, I want to pull through onto a new sheet the top ten listing from the bottom of the 50 rows but the name of the person from the top of the 50 rows... So far I have the top ten in figures coming through on the...
19. ### Cross Value Across Two Sheets

I've been trying use excel to figure out amounts reserve Soldiers would be paid for working a certian number of days. I need to cross reference rank and time in service for each Soldier. I decided that it would be faster to use excel and use a cross reference formula to figure it out. I've tried...
20. ### HLookup Help

Hi, For example, I want to lookup this table: And fill up this table using HLookup: =Hlookup(lookup_value,table_array,row_index_num,range_lookup) I'm trying to do a HLookup but i want the row_index_num to increase as I copy down the rows. How do I do this? Thanks in advance.

### This Week's Hot Topics

• populate from drop list with multiple tables
Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
• Find list of words from sheet2 in sheet1 before a comma and extract text vba
Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
• Dynamic Formula entry - VBA code sought
Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...