1. H

    Multiple match criteria in different columns to return the unique value

    Hi, Can somebody help me with this problem? Thanks, Bobby
  2. mamady

    Lookup information from another sheet using VBA

    Hi All, I have a list of information in sheet 1, like the following table Country Month Subject Item and in sheet 2, I created a layout with a drop list for Country and Month attributes I want a VBA code that will retrieve/lookup the subject and item based on select...
  3. asokaw

    Find the REF No where the Amt is = to the same negative amount

    I need a formula to show the REF No to be inserted in Result Column when the Amt is = to the Negative Amt as shown
  4. M

    Best approach for top sales deals?

    Hi - Thank you in advance for the help. I'm working on a sales runbook that combines actual and pipeline data to get to a forecast for the quarter. The sales leaders need to be able to determine, at a specific opportunity level, if an opportunity is going to close this quarter or not. If it...
  5. J

    Find closest values

    Hi, I'm new to macros and can't find a good starting point for my problem. I want to loop through a row in a table looking for the 3 closest numbers (column D) to a value in a given cell (N5) and set the corresponding row to "yes" in column B. So if the 3 closest values is found in D3, D6 and...
  6. K

    Index/Match returning first non-blank cell

    So I understand index/match will return the first instance of the match it finds, even if the answer is "". What I need is a formula that will return the first instance where the cell is not "". Here's an example: Customer No. Salesperson Code C000176 C000176 DG C000176 DG C000176 DG...
  7. B

    Partial match when look up value is lengthier than corresponding value in a table or a range

    I have table as below. In first column name of the company and in next column corresponding manager Name. Company Name Manager Name Amcor Amol Thermax Sagar The look up value of company name is not exact match in this case. e.g. It is "Thermax Ltd" The company name from table is a...
  8. L

    List default based on users information

    Can I have some help please? (See attached image) I have 3 tabs. the first sheet has employee’s data. UserID, Name and Level Second sheet is where I want the help. There sheet shows the users name and level, the level cell is a dropdown list containing all the possible levels. (The list values...
  9. E

    Index Match Formula Shows Wrong Result

    I have two table, this one is the initial table that contains raw data (on Sheet 2) ABCDEF1NoUserDateTimeActivityDescription2A-1Staff 305/06/20209:00testtest3A-1Staff 305/06/20209:30testtest4A-1Staff 305/06/202010:00testtest5A-1Staff 305/06/202010:30testtest6A-3Staff...
  10. D

    Extract all rows from a range that have specific text from lookup

    Hi all, I have an excel file with multiple rows and columns used for planning jobs. The columns contain job descriptions, job numbers, Worker names etc. Few jobs require 2 people to complete and have 2 names on them ex: Luke and Mike. Out of all the jobs i want to extract the jobs for specific...
  11. M

    VBA - Lookup Entire Row from List

    Hello, I am using VBA to create a user entry form where users select certain account numbers from a series of data validation dropdowns (this is already done and functions properly). The workbook also contains a second sheet with all accounts the user could choose from and their attributes...
  12. 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...
  13. D

    IF function comparison

    Hi, In the file attached, there is the Group column (B) and Name column (C) both of which are related to each other. I need a formula that would return a value under certain conditions of what is inside columns B and C. If e.g. the column B value is USA, but in column C we have "wood and...
  14. A

    Salary Table Lookup

    I have a salary table that I would like to lookup a grade and step and find the corresponding annual, hourly, and overtime rate. I have tried a vlookup and index combo but can't get the correct returns. Any help is appreciated. Below is what I have so far...
  15. L

    How to return the starting balance of a bank account in a master list of bank accounts

    Hi everyone, I've built a workbook that evaluates a client's banking information and processes multiple bank accounts at a given time. I'd like to find a formula that will return the starting balance of each unique bank account from my dataset to reduce human error with data input. The...
  16. F

    Sum by Year Index Problem

    Hi, I want to sum a data table by year. How do I do that? 'Summary' tab - lookup Product A in the 'data' tab and sum the monthly expenses of Product A by year. https://docs.google.com/spreadsheets/d/1N76bSX4PbzdknOg3qbGBU2i5t6sD2Ld1LHJxzhD_SzM/edit?usp=sharing
  17. N

    Lookup Formula/VBA to find correct duplicate

    Hi there, I am looking for a formula/VBA solution that will lookup an ID in a separate list, then, if the ID appears in the list more than once, I want the formula to look at the date in the first list and find the ID in the 2nd list with the closest date match before returning the value in...
  18. J

    Vlookup error

    I have a vlookup in one spread to look up qty's in another and is erroring #N/A. when I go to the lookup table and click in the cell and hit F2 and enter the error goes away. so I then try to copy this down and I have to go cell by cell hitting F2 enter. not changing anything. is there some...
  19. D

    Formula to extract specific text from cell

    Hi everyone, I have a pretty puzzling task (hopefully not for you guys). I need to perform a vlookup between 2 sheets to see if an ID exists in the other sheet. My problem is, in Sheet A, the id is one Id for cell. for example: G-1234 G-1235 G-1236 G-1247 However Sheet B is a...
  20. A

    Formula required for work - Lookup Matrix to provide result in cell

    Hi All, I have this assignment at work, and i tried bunch of formulas but cannot get this (hopefully) easy formula right, i have tried INDEX, MATCH, COLUMN, COUNTIFS, SUMPRODUCT but all to no avail; i cannot comprehend the complexity and turn it into simple logic. In the image attached, i have...

Some videos you may like

This Week's Hot Topics