1. B

    VLOOKUP returns nothing / Macro gives me an error message

    Hi I presently have vlookup formulas in numerous cells that are linked to a value entered in cell F18 and a macro is linked to a value in cell H31 I need a macro that will generate a message box if the number entered in cell F18 is not found during the vlookup on Sheet2 which in turn will not...
  2. M

    VBA Vlookup between two workbooks

    I need to vlookup with two workbooks and find the match values with highlight. Workbook A (Located in the folder path C:/Desktop/price match MFR date beg date end price XXX-ltd 8/1/20 8/1/20 100 YYY-ltd 9/1/20 9/1/20 200 GGG-ltd 10/1/20 10/1/20 300 MMM-ltd 11/1/20 11/1/20 400...
  3. M

    Using Index/Match or Vlookup to get one result out of multiple results

    Hi there. My very first post here. I'm an intermediate Excel user and have been working on a project. I have a problem where I am using Index and Match formula to index one result (Using Match formula to determine both the row number and the column number in the Index formula). The problem is...
  4. H

    Multiple match criteria in different columns to return the unique value

    Hi, Can somebody help me with this problem? Thanks, Bobby
  5. M

    VBA Vlookup - if part number not found then display Msgbox and Exit Sub

    Hello, I have following macro which on Error will resume to next. Now I want to display a message box if an error is found and after exit SUB Message box( "Part number" & "PN" & "not found. Please define packaging details") By PN should be displayed the part number that is not found. Sub...
  6. E

    Formula Help

    I am trying to compare dates between 2 different worksheets in the same workbook and summarize differences on summary worksheet. First I would need to search by ID number to make sure I am looking for the correct line, than look at the close date, compare this to the other worksheet using same...
  7. G

    Vlookup index match across multiple sheets and average values

    I have a list of Golfers in my "Summary" tab where I want my vlookup to find the golfers name in each of the four sheets and then look at a specific column and average those values in the summary sheet. Is this possible? I have been looking around and have not seen anything pertaining to the...
  8. J

    Using Vlookup and Index/Match across differing sheets

    So I have one table with differing columns of ID and its information per row on 1 sheet and another sheet has ID that asks for associated data from different columns. Eg ID is A column and info for associated is in D,E or B column. Each row has unique information. On another sheet is ID and...
  9. H

    Sum values based on multiple words found in string of text

    Hello, I have what I think to be a tricky VBA job. I have two tables, one with single names, and the other with full names. I am going to assign a numerical sum based on the combination of single names found in full names. For example: Bob = 5, Michael = 6, Scott = 7. With name and number...
  10. 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
  11. H

    Vlookup cross reference two parameters

    I have a scenario where I am looking up supplier prices in one spreadsheet and putting them into another in order to produce a client quotation. In one tab I have information on our suppliers and their discount structure and on the other I have their prices. Some of our suppliers offer us...
  12. P

    Combined use of ISBLANK, VLOOKUP, IFERROR

    Hi, I want to use multiple cases in single cell. Case 1 : In ‘B3’ cell value are appearing by using VLOOKUP from cell ‘A3’ Case 2 : Want to use IFERROR to avoid #N/A in cell ‘B3’ Case 3: If cell ‘C3’ is empty then cell ‘B3’ should return to empty. I am able to combine case 1 and case 2. Now I...
  13. M


    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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

Some videos you may like

This Week's Hot Topics