hlookup

  1. N

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

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

    Going Crazy, Please help.

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

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

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

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

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

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

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

    Vlookup/Hlookup Alternative

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

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

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

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

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

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

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

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

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

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

    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.

Some videos you may like

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...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top