vlookip

  1. B

    VBA: Vlookups to auto-populate data into a list - can it be more efficient?

    Hi, I have created some code for doing some vlookups to auto-populate data into a spreadsheet list. Against each record, the user selects the correct value from a drop down list, then, based on the value chosen, the vlookups find the matching value from a different sheet (the ‘Hosts List’) and...
  2. K

    Combining VLOOKUP and IF statements

    I'm trying to combine two sheets using VLOOKUP but struggled as the columns weren't contiguous. I think the best way to do it is using IF to search each value individually. It all gets quite complicated because I am trying to use data from two sheets. One sheet already has calculations on it...
  3. H

    Vba code for qty data update

    Hi Team, I am looking vba code in order to get desire output. I have several columns which contains product details, there is column called "Qty" we get request from customer and will order the goods based on available qty in our store. If available in store then will get it otherwise will get...
  4. J

    Converting a 6 letter column to a 2 letter column using Vlookup. How do I do this?

    I have two columns that read: XXHSXX HR XXTRXX MG XXXFXX XG XXHSXX HS XXTRXX MG XXMEXX R$ XXHSXX HR XXHSXX XXTRXX XXTRXX .... The above list represents 2 columns. The left column is 400 lines long. The right column is partially complete with 2 letter codes that represent...
  5. H

    vlookup & if Lookup_value is matched, return 1 else 2

    I am doinf vlookup in 2 wokbook. If the Lookup_value in both the workbook is EXACT, then answer=FOUND else NOT FOUND. How to accomplish. Workbook1 A1=PPP999 Workbook2 A1=PPP999 So, in D1 of workbook2, Answer=FOUND
  6. S

    Dynamic Vlookup by VBA

    Hi all Need to accumualte values from a repeating Vlookup using VBA but cannot get the Vlookup to take dynamic ranges Sub test() Dim myrange As Range Set mytable = Worksheets("sheet2").Range("A1:I10") Dim accum, mycol, myrow, currentval, Collimit As Integer 'Inial position to look mycol = 4...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top