vlookup

  1. M

    INDEX, MATCH type COUNTIF/SUMIF issue.

    Hi everyone, Last time I reached out to you, I felt the love with so many responses so quickly. I am a teacher and I’m trying to look for ways to streamline my duties. I'm currently reviewing the courses I teach - focussing on equipment used, and duration for each module. I have been asked...
  2. R

    Vlookup and Match-Need VBA solution

    I am facing a problem with vlookup and i think could not solve using the Excel formula The column H values to be checked in Column A and if the words in a cell match, then it should collect the adjacent values and display in Column C and D with comma seperated. The column H values to be...
  3. P

    Excel Formula to Refer to three conditions

    Hi All I have excel file under Role column i have (Maker,Checker and Supervisory) and under Activity list i perform, Now in sheet 2 i have predefined time . So i need formula if anyone selects either Maker or checker or supervisor respective time should come from sheet 2. Could you please help...
  4. M

    Using Vlookup to return cell values between dates

    Good morning everyone, I am stumped on how to get my monthly and annual roll up data to properly display using Vlookup. I have set up a helper column to assist the daily data but I honesty cant figure out the best way to get Excel to total data across a month for a given metric. I currently...
  5. sycodiz

    Hlookup/Vlookup help-this should be easy but I just can't figure it out

    I have a very simple excel sheet. I am going to break out sections and give them to different team members. No team members will have the same data. I need to match on Vendor number (Rows) and dates (columns) as shown below. The main sheet will be pulling the data from each of the other sheets...
  6. T

    How to automatically generate the next logical number for a list in Excel

    Hello, I have a list of numbers, the list is not in order nor does the list always start with the same starting point. My need is to find the next logical number in the list (I've tried vlookup/max/index etc). The closest I got was a combination of max + 1 combined with vlookup. However, this...
  7. L

    Index match, xlookup or both?

    Hi, I'm trying to find a way to return a value based on an index match formula, if the returned value is 0 then move up until there is a number. Column look up: A Row look up: 4 A B C D E F 1 0.34 0.36 0.24 0.75 0.37 0.12 2 0.15 0.74 0.35 0.01...
  8. M

    Vlook up between two workbook and display message

    Workbook A,sheet 1 Supplier Amount Owner status Date AVT 500 John 4/22/2020 ABC 1000 Peter 4/21/2020 NAC 600 John 4/22/2020 BAT 10001 Andrea 4/23/2020 Workbook B, sheet 1 Condition should match Supplier, Amount, Date, If all matches in sheet 1 of workbook B with Workbook A...
  9. A

    Pulling List of Rows from other sheet dependent on matching Cell Value? HELP See Pictures!

    Hello, I have a workbook with Sheets 1 and 2 with data on them. This template is on Sheet 3. The template uses the cell D5 to pull data from these different sheets to populate. You type a project number (Proj#) in D5 and the rest should populate. On "Sheet 1", I have a listing of all the...
  10. C

    Vlookup combo box value to populate textbox

    Hi everyone! Newbie here, I have a small Userform with a couple of textboxes and one combobox. The combo box is populated from a sheet named "Nombres" ComboBox1.List = Sheets("Nombres").Range("A1:A130").Value So what I need is that, after the User select or change something in the...
  11. T

    Lookup with changing header columns

    Hi, any suggestions would be greatly appreciated. Below are two example files I receive from a vendor. The file is usually massive but for this purpose, I'm showing simple tables below. The old formula I used was INDEX/MATCH to pull in Mary's phone to a different spreadsheet called MAIN. On...
  12. J

    Conditional Table Array for Vlookup?

    Hello, I am trying to vlookup a value for a competitor product based on 3 criteria (that determine product group and its exact specifications). I was hoping I could use some logical function, that would then somehow choose(locate) and use a desired table array from which to look up the data...
  13. M

    Vlookup with workbook in a same folder

    In the below workbook A, with file name starting MarkList_12_4_2020.xlsx and sheet name as file name in stored folder (C:/Desktop/Mark) Name Mark Class Grade John 50 Post Graduate A Peter 50 Preschool A Andera 100 Nursery S In the another Workbook B, is the fixed Existing report...
  14. S

    Dynamic VLOOKUP

    Hi, Wonder if it is possible to have a formula that dynamically looks up values from a table as the reference cell instead of manually typing in each one. Once it finds a new VLOOKUP value it would use that by default until it finds the next value in the table and so on. In the example below it...
  15. T

    VLOOKUP shows #N/A

    I can't get why..
  16. C

    Advanced Formula Help - INDEX MATCH MATCH? VLOOKUP? Please help :(

    Hi guys, Wondering if anybody can help me - I have been trying to figure out this formula for 2 days now, with no luck :( I'm trying to figure out how to use Excel to find and return a value. It's quite difficult to explain (sorry, my brain is exhausted after trying to figure this out), so...
  17. H

    vlookup to check condition if DATE is between two dates (in two separate columns)

    Hello I am trying to find if a date is between two dates then find the row and category against those dates. Table 1 -Column C is my goal. Any excel formula to arrive at this solution? For Item A- created on is 4/2/2020 so I need to check Table 2 for Item A and see if 4/2/2020 is in between...
  18. F

    Vlookup in database for multiple cells

    Hi, its me again, I have another problem, the thing is that I want to find the name of multiple Stores, I have the store id and I have the Stores Database in another worksheet, the the thing that I want is to run a macro that search me automatically every code that i put in a extensive...
  19. M

    Vlookup when multiple same value in both columns

    I want to vlookup with supplier and product with other file "Comparing file" which has supplier and product. if value matches and status is completed , Mark as Yes in output Supplier Product Status Output AB XY-1 Completed Yes AB XY-1 Completed Yes AB XY-2 Completed Yes BC ZA-1...
  20. M

    Search Attendance Sheet to see if people who registered attended (by their email) and set a cell to yes or no value

    I am looking for a way to search from one cell in my registration sheet and see if the string in that cell appears in column in an attendance sheet (to see if they showed up). If so I would like to just have the word Yes appear in Column T of the registration sheet. I would like to do this in...

Some videos you may like

This Week's Hot Topics

Top