lookup value

  1. P

    VLOOKUP Fails

    I've built a timesheet with 15-minute increments. Users enter their task and what project the task is part of, and a single project can have multiple tasks. All projects are in one column and all tasks are in a neighboring column. Total time is listed beside them. The range is D2:G166 (NOTE...
  2. jrn1392

    Need to return column heading of value in a row

    I have a table of days for various feelings. Ages are going down column A. In row 1, columns B through G are the feelings. For example: <tbody style="box-sizing: inherit; border: 0px; margin: 0px; padding: 0px; vertical-align: top; -webkit-font-smoothing: antialiased; text-size-adjust: none;">...
  3. J

    VLOOKUP w/ Wildcards in my LOOKUP VALUE.

    My lookup range consists of a table of chemicals. Below will consist of entirely examples (not real data): [SHEET 2] LOOKUP RANGE: named Table1 CHEMICAL SCORE chemicalA 46 chemicalB 55 Chemicalc 45 ChemicalD 45 [SHEET 1] My lookup value might sometimes have an extra space...
  4. M

    Vlookup Loop through Lookup value & range

    HI, i have a file containing 2 tabs . first file contains a list of items extracted from bills of material saved at second tab. I am trying to check where use of each item in the first tab (template) from second tab (Data). But as there is very large number of items in both tabs , its not...
  5. N

    Merging 2 datasets with vlookup to a higher or lower value?

    I have been struggling to find a formula that works for the example below (see question mark!). What i am trying to do is merge 2 datasets. The problem is that the common identifiers are not always exactly the same but quite similar nevertheless. I tried using the vlookup function making the...
  6. P

    Replace Header based on Max Value

    Hi I have the following problem. First Row is the Header <tbody> Name of Student Visual Auditory Kinesthetic Major Strand Name Student 1 1 2 3 3 Kinesthetic Student 2 3 4 2 4 Auditory Student 3 5 3 1 5 Visual </tbody> In the above table, I will be filling all columns upto Kinestheti...
  7. G

    Dynamic lookup value requires correct syntax

    Hi, I am trying to create a lookup that will get the parts with the highest chance of being used depending on the location. I figured out the formula in Excel, but I needed to convert into VBA. I used the recorder, but I need to add a variable to the formula, so the lookup value of my formula...
  8. M

    Returning value when multiple criteria are met.

    I have 2 spreadsheets where 1 has partial, already selected data from the other. I want to get the value of column G when 5 criteria are met. In other words. I need to to look at the 5 other columns in that row and find the same combination in the other spreadsheet and return the value. Its...
  9. S

    Search Column in one sheet for a specific format and output the found values to a column in another work sheet.

    So I have two worksheets. One with raw data imported from a .txt file and another that I plan to use to organize and pull the data I want. I would use Access but the formatting of the .txt file does not allow for easy importing. I am trying to search the Cells in Column Data!A:A for product...
  10. V

    find date interval and lookup value

    i have compile a table that would determine the value im looking for, please see below: A || B || C || D || E || F 1 || Start Date ||End Date || Debit Month 2 || 19-Apr || 15-May || MonthA 3 || 17-May || 19-Jun...
  11. Futile Crush

    Using VLOOKUP to find something that is greater than / less than the lookup value

    Hey guys, I need a bit of help. I'm trying to make a VLOOKUP which looks at the lookup value, then finds the value in a certain column of a table which is greater than or equal to that number, and returns a specified result within that row. My attempts have thus far been unsuccessful. Without...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top