hlookup

  1. C

    I can't remember how my formula works

    I'm trying to add to spreadsheet I made a couple of years ago. I need to tweak a formula to put something similar-ish in another cell. I know what the formula ends up producing but can't remember how it works. Can anyone translate each of the steps in this for me please...
  2. A

    Conditional Formatting with Hlookup and greater than

    Hi, I am trying to highlight a cell Q11. I want it to Hlookup cell Q5 in Columns BV:BX and then if Cell Q11 is greater than the Hlookup for it to highlight Cell Q11 in Green. I hope this is clear. Thanks for your help Dan
  3. L

    Need to lookup a value, meet horizontal criteria, return header

    Hi, I'm trying to lookup a value in a named table (Zoo), then search horizontally for the first match or if there is no match, the next greater number, and return the header. Values in the columns will always increase from left to right. Example: Sam 7 Result: monkey Example: Sue 9 Result...
  4. C

    Sum values with horizontal and vertical criteria

    How do I SUM values where one criteria is on vertical axis then the another criteria is on the horizontal axis? I.E, if I wanted to sum the BEACH for June only <tbody> MONTH WEEK BEACH DENIM DRESSES JERSEY KNITWEAR NIGHTWEAR OUTERWEAR SHIRTS SHORTS JUNE 1 0 2 1 1 1 1 1 1 1 JUNE 2 255 382...
  5. N

    Look up in a table, and return the value of the first row.

    Hi guys, I dont think this one is difficult, but I cannot find a good solution :) Maybe one of you can help :) I have a big table: <tbody> A B C D E String String STring String String String STring STring String STring String String String String String String STring String String...
  6. sycodiz

    Average, V or H lookup, match, percentage crazy formula help needed

    Wondering if someone out there can help me with a crazy formula needed. What I am trying to do: In J, Find the audit date in A2 within c1, d1, e1, etc. Starting with that found amount, has the amounts after steadily increased? What percentage over the average inventory has the store increased...
  7. 7

    COUNTIF using HLOOKUP as start range and 'last blank cell in row' as end range (maybe)?? Help Please

    Hi All, Need help with 2 formulas, kind of related as both need a HLOOKUP start range and 'last blank cell in row' as end range (i believe), any help will be greatly appreciated....... In column M (M2:M5) i need a formula along the lines of...
  8. J

    HLOOKUP then check if flagged as result then return value

    Sheet1 <tbody> 2019 2020 1234 54 66 5678 14 44 </tbody> Sheet2 <tbody> 2019 2019 2019 Result Flag Result 1234 54 51 77 5678 14 28 101 </tbody> =HLOOKUP(B$1,Sheet2!$A$1:$Y$4,MATCH($A2,Sheet2!$A$1:$A$4,FALSE),FALSE) Hi, Above you can see a shortened...
  9. R

    Find Column Value from Lookups

    Many time user....first time poster :) I am looking to return a column value from a single row based on two variable (one in rows and one in columns). Hopefully it makes more sense in the table! I have 'over engineered' a solution but hoping for something more streamlined to save workbook bulk...
  10. H

    How to pull in multiple fields with a VLOOKUP?

    Hi all, I am trying to write a formula where I can put start with the data in Table 1 and then write a formula in column B of Table 2 to pull in the correct ID numbers from Table 1. Essentially I want to do a VLOOKUP, but I need the VLOOKUP to pull in the data from all rows that meet the...
  11. L

    Sheet Reference and Multiple Criteria Lookup Formula?

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

    Extracting Row in multiple tabs by keyword

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

    Hlookup using Sheet Name lookup

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

    Converting an HLOOKUP to Index and Match

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

    Vlookup Hlookup help

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

    Sum based on multiple column headers and row

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

    Conditional Formatting and Automation

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

    Building HLookup and If formula

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

    Sumbycolour and hlookup

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

    Hlookup and Interpolation

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

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top