vlookup & hlookup

  1. J

    Referencing Multiple Columns

    I am trying to sum up stock that was received in a given month to each individual location. I can't do a vlookup because the same item might hit multiple locations and not give me the correct quantity received in at that location. I have two separate worksheets. One worksheet is a summary of...
  2. S

    Find and Replace with lookup table with mutiple conditions (Categories)

    I have two sheets: the first with data with column headers as 'Line#s' I need to change based off of a lookup table on the second sheet. Both tables have an overall category (ID) and sub-category (Type). The header names in the lookup table vary depending both categories. I need a condition...
  3. S

    get 4 words before a match found included match word

    In ColumnA I have sentences wrapped and in columnB list of words formula should lookup range of words in columnA and get 4 words including matched word. for example. Robert is honored in computer science and Robert earned GPA 3.6 and he has a bachelors degree (ColumnA) 3.5 (ColumnB Range) 3.6...
  4. T

    Using LOOKUP over multiple sheets

    I have a multi-sheet workbook which has some sheets called Week1 Week2 etc. I also have a sheet with a range of dates in column AB4 to AB35 In the worksheet Week1 etc, I have dates stored in row B5 to H5. I have a named range called "SheetList" which contains the names of the worksheets Week1...
  5. L

    INDEX MATCH Formula help

    I'm working to get an index match formula to find a value in one table based on criteria in another. An example of each table is below, with my desired output being in the "Price" column of Table 1. Table 1: <tbody> Column A Column B Column C Column D Row 1 Thickness Type Width Price Row...
  6. C

    Vlookup With Conditions

    Hello, I am trying to lookup a data from table 1 to table 2 however, the vlookup is not matching locations and picking up the first role it finds: See below: Column A Column B Column C Column D Column E Column F Column G Column H <colgroup><col><col><col><col><col...
  7. G

    Matching a vertical data set with a horizontal set

    Hello, I need to fill in a table by matching the vertical number in Column J with the horizontal number in Row 3 and then entering a 1 if they match or blank if they do not match. I've added a 1 at the intersection of N4 because both the vertical and horizontal numbers are 31494. Table looks...
  8. S

    If column is not empty, return values from other columns in same row.

    I have searched the forum for a suitable technique to solve this problem and I can find nothing that helps. I have a spreadsheet that tracks a large number of staff and changes to staff status. worksheet 1 contains the core data and tracks changes on a week-by-week basis (each week starting...
  9. T

    Help with Formula (VLOOKUP)

    I am trying to determine if certain we a purchase a particular stock occurred between multiple time periods- see pic, but in short I want to search Column L for B2, and check if the date in A2 falls between any of the date ranges for the occurrences of B2. Sorry for the illustration I couldn't...
  10. S

    Excel Multiple Vlookups (?) with transposing (?)

    Hi all - I'm new here and really hoping that someone can help me before I pull all my hair out! This is a sample of the data I have. I have over 24k rows that look just like this. <tbody> Group ID Merge Key Master Record Exclude Record Record ID Key Indicator Constituent Import ID G-1...
  11. W

    Vlookup on columns and rows

    Hello, I need to do a Vlookup using criteria from the columns and rows. For example: <tbody> ID/CLASS APPLE BOY CAT DOG EGG FAN GUN HORN INK 1243 5,600 765 1,123 1445 2,434 112 445 9,400 2,454 3243 3,001 223 7,210 222 30 2112 3,233 211 448 101 2,444 6756 9,312...
  12. F

    Pull Data From Two Tables Using 2 Drop Lists

    I am attempting to match data (state and year) in two tables that have the same h row and v column headers by using 2 drop list <tbody> State Year Population Cases Drop List Drop List Result From Table 1 Result From Table 2 </tbody> Both tables would look similar to the following: Table 1...
  13. F

    Pull Data From Two Tables

    I am attempting to match data (state and year) in two tables that have the same h row and v column headers by using 2 drop list State Year Population Cases Drop List Drop List Result From Table 1 Result From Table 2 Both tables would look similar to the following: Table 1 (Population)...
  14. A

    An alternative to nesting Ifs to get results.

    Hello All, Thank you for your time. I am in need of your assistance in finding a better way, a more efficient non-vba way, of getting the results I get from nesting Ifs. I currently pull data from our main frame and do a visual scan. I developed a crude If statement...
  15. oldeirish

    Trying To Use Formulas To Add Numbers with Only 2/3 Sets of Criteria

    I’m looking to create a formula that will look at two separate columns [Status] and [Quarter] and select (for example) HP in column F and Q1 in column. Then add all those particular numbers located in the G column and add them. Example would be an outcome of all numbers added would have both...
  16. P

    Make a workload of a particular teacher

    Help Required My problem is i want to past the complete cell of that particular teacher with (subject, name of that teacher & Class) in there receptive ROW, it will help me to know which subject & Teacher and which class that particular teacher is teaching in "Sheet 1" i have highlighted...
  17. T

    Help with Looping through a vlookup xl2010

    I'm new to coding VBA and have coded a good amount of what I'm trying to do, but there are a few things I'm having problems with coding. I think I might be able to figure out a few of the other issues I'm having with my code if I can first figure out how to loop through a vlookup to complete...
  18. M

    Vlookup

    Is it possible to run a VLOOKUP or other formula to compare two worksheets, then if Cell A is present in both of them return the whole row on a third sheet? Is this possible?
  19. S

    Vlookup & hlookup??

    Good day.. I am trying to look up an item in a row on tab one and then look at the top row in serveral columns in tab two and bring back the data. The top row in each column might change monthly so I don't want to formula to find the column and then bring back the data. Below is an example...

Some videos you may like

This Week's Hot Topics

  • Use Filter function with 2 criteria to return a specific value
    I've spent many hours trying to find out why the basic formula for Filter function with 2 criteria will not return a value other than #CALC. I'm...
  • Loop stopping at row 10
    Below is a code I had a lot of help with from user such as yourself. This code worked well but now is stopping a row 10 and I can't see why! Could...
  • Numerical Order Code for Macro
    I am trying to find a code or fix what i have on the macro that will automatically make the certain column generate in numerical order when I...
  • Calculate time in excel
    I get a text report from our time keeping system that i dump into excel through a data connection and I need to calculate the total hours for a...
  • VBA
    Hello everyone, I need your help please. I just need VBA code to get my reports working. What I want to do is whenever these dropdowns are...
  • Help with formula to sum numbers prior to date
    Hello, I was hoping to get some assistance as I'm having trouble with this. Using my table below as an example, how could I write a formula which...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top