vlookup

  1. A

    PLEASE HELP!!! Can Not Get Formulas To Work??

    I need to know what the VLOOKUP FORMULA is for moving numbers between these 2 sheets because I can not figure out the formula myself. I have tried all day, and I can not get it. JUST LIKE IT SHOWS IN THE SCREENSHOT ABOVE. I have 2 sheets named "Testing Day 1" and "Month 1 Week 1". I want to...
  2. T

    Need help nesting a VLookup inside an index, I think?

    Hello all, I've got a problem with a table I set up. Here is the reference table: 2019-20 2018-19 2017-18 2016-17 2015-16 2014-15 2013-14 2012-13 2011-12 2010-11 2009-10 2008-09 Division # Div Name Division OH Division OH Division OH Division OH Division OH Division OH Division OH...
  3. J

    Vlookup Help Please.. :)

    Hi there, I am struggling to get this to work and its bugging me! i hope you lovely people can help me. Basically if the content within column A and B of sheet one, matches the content of column A and B on sheet 2, then insert date from column D on sheet 2 into column J on sheet 1 I hope...
  4. P

    Looking for help with v or h lookups

    Let me start by saying I am a pretty newbie to Excel - I know the basics but V/H lookups are out of my capabilities. What I am looking to do: I have bike mile logs on two sheets and on a third are thee highest or max for a particular stat. I was able to create the max sheet but what i would...
  5. I

    Index match not working for grater than value

    Hi there! I'm trying to make the index match formula work for -1 (greater than values) as I don't have the exact match for the value I'm looking for: I have an invoice table and a tariff table and based on the value of the weight in the invoice I need it to get the cost. If I use vlookup (image...
  6. M

    Vlookup in Excel VBA for Data Entry

    HI Excel Expert , Request your valuable help in solving the below error . PS: Am new to Excel VBA coding . I have got 3 Sheets in the attached workbook “Just combo V2” Download link : Just combo V2.xlsm Sheet 1 Sheet 2 =”School” in which Cell A1 : A14 Contains list of schools Sheet 3...
  7. ThereIsNoSpoon

    Using VLOOKUP to search two coloumns but return one value PLEASE HELP!!

    Hello all, I would greatly appreciate help from somebody regarding this problem I currently have. It is frazzling me. on the commercial invoice sheet that I had created, I have a slot for a commodity code to be automatically filled using a VLOOKUP formula. This is powered by a drop-down menu...
  8. E

    VLOOKUP only matching the first row and will not copy/paste

    VLOOKUP will only match the first row value and then continues to replicate that value when I copy/paste it down the entire column. It won't change the formula from $A$1 to $A$2, etc. It just stays at $A$1. It is set to Automatic so it is NOT that issue. I have also tried removing the $ in...
  9. N

    Need Help With Wildcard Vlookup

    I have a list of items that I need to be able to use a vlookup to see if it contains a certain string of text. For example I need to use the below items to be able to do a look up based off everything before "-4". I know I could do an =len and then use that to do an =left to get rid of the -4...
  10. E

    Vlookup with "inversed" wildcard

    So I think I generally understand how the "*" wildcard with vlookup works, but I need an "inverse" wildcard. Below is an example of my challenges: I have a list of Responses (column B) (over 2000 responses) that vary significantly but I need to recode it based on the "sample table" For...
  11. T

    Skip Empty Cells With VLOOKUP or INDEX

    Hello! I am trying to use either formula above to give me the performance of a specific employee while skipping empty cells. I have VLOOKUPs and several other formulas at play for different cells but the formula I am attempting to create is calling a page that has one or more blank cells for...
  12. S

    Lookup (not sure whether its X or V or H)

    need help to find the result as per below. can someone help me please. ABCDEFGLMNOP3NoEmployee NameP RatingCriticalityResultReference Table41MARCUS LIMD3CriticalityP Rating52ELIZABETH TAYLORC3DCBA63KEVIN COSTNERB31D1C1B 1A174LIM AH LIMA32D2C2B2A285ABDUL PATAHD23D3C3B3A396LEE KUAN YEWC2107NG...
  13. D

    Vlookup to return Multiple values

    Hello Excel Users, I have a spreadsheet with multiple tabs where the first tab has unique numbers and the other tabs has the the unique numbers with multiple values associated to it. I need to have the first tab return the multiple values from the second tab. Column B in the first tab is what i...
  14. S

    Need help DAX LOOKUP formula which would work like VLOOKUP

    Hello Everyone, I have two tables Table 1:- Voucher No. Invoice No. Invoice Amount Invoice Date Vendor Name 1 ABC-1 100 14/05/2019 ABC Company 1 ABC-2 200 14/05/2019 ABC Company 2 EFG-1 300 31/05/2019 EFG Company 2 EFG-2 400 31/05/2019 EFG Company 3 XYZ-1 500 30/06/2019 XYZ...
  15. A

    Data Range too huge and VBA takes longer time to complete run formula

    I have this code to insert vlookup formula into a range of data, due to the lines is over 50K, it takes very long time to complete the whole process. Anyway to avoid this running time and able to apply the formula successfully? Sub LookupPrime() Dim r As Range Dim s As Range Dim...
  16. C

    VLOOKUP OR INDEX? Duplicate values exist, keep non-blank value (text & numbers)

    I have a very large spreadsheet that I am trying to return the value of some columns based on matching depths. Tab1 of my spreadsheet has no duplicate depths while Tab2 DOES have duplicate depths, some of which the columns have null values. The attached Example Tab1 image has a yellow...
  17. C

    Mix of Vlookup, find and substitute

    Hi All Have issues with this formula =VLOOKUP(FIND("*",SUBSTITUTE(A8,".","*",LEN(A8)-LEN(SUBSTITUTE(A8,".","")))),Data!B:C,2,0) What i want is to do a Vlookup on everything in the cell up to the full STOP (.). This formula is giving me the position of the last full stop...
  18. G

    VBA VLookUp to another workbook

    Hi! I have two spreadsheets (A and B) and I'd like VBA to do a VLOOKUP from A to B. Once the ranges are dynamic, I defined counters and they are working, I checked that. So there's the loop, contador stands for the counter in spreadsheet A. It should look for the content of cell Y&counter in...
  19. 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...
  20. 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...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top