vlookup macro

  1. E

    VBA Vlookup Troubles

    Hi, I have spent two days googling and searching old threads to no avail so I'm posting here in hopes that someone can help. I'm trying to automate 2 vlookups using VBA. I will receive reports daily where will we have to do vlookups to pull the advisor name and program name. So I have 2...
  2. J

    VBA Macro for Multiple Columns

    Hi, I am looking to run Vlookup formual for below table from the 3 subsequent tables (Alpha, Bravo & Charlie) below for each month with each sub columns such as Alpha, Bravo and Charlie. Request your help in creating a Macro coding to avoid manual vlookup to fetch data in the first table...
  3. M

    Vlookup formula to loop between numbers in a coloumn

    Hi, I am working on a formula for which I think I might need a macros. I have a vlookup formula that looks up a value in column D, and matches the returned value (column E) with column B. If there is a match, the value in column C is returned. However, the vlookup needs to be applied to several...
  4. E

    Collection of question, help is much appreciated!

    Hi there, I'm trying to get myself a couple of macro's working, however there are a few errors I'm walking into: 1. When doing a VLOOKUP between 2 sheets in the same workbook, it randomly #N/A's certain hits, this does not happen when I do the same VLOOKUP on separate workbooks. 2. When...
  5. N

    Why is this excel vlookup macro giving me an "object required" error?

    Hello, I'm trying to figure out how to add a vlookup to a longer macro I'm working on but I keep running into a variety of errors. I ended up creating a new Sub () to test out a very simple vlookup macro in the hopes of figuring out what's going on. I went to this website VLOOKUP In VBA and...
  6. L

    Vlookup Macro

    Hi All, I have query regarding vlookup macro. I have recorded a macro for vlookup and its working for selected data (100 columns only) but if i add/delete few rows/columns macro not working for add/delete rows/columns. I need a vba code which should select based data availability. Not only...
  7. M

    Problem with remote file, vlookup, and filename automatic update.

    I'm creating a spreadsheet to track a spreadsheet that's located at http://tomato.ftpaccess.cc/shares/spreadsheets/(month)/mmmm dd, yyyy.csv. Before now I've been using a local copy [E:\Downloads\Spreadsheets\June\june 1, 2010.csv] which has worked fine. How do I use the remote file from my...
  8. F

    Vlookup with macro with range on 2 worksheet

    How to create macro vlookup with range based on 2 worksheet... Let's say : In one file, i have 3 sheets. 1. the form i want fill with data form sheet 2 and sheet 3 2. the data source part1 3. the data source part2 sheet 1 <table x:str="" style="border-collapse: collapse; width: 720pt;"...
  9. P

    Vlookup VBA Variable

    Dear all I have the following code, I am trying to check if there is a value above 0 through the lookup. Dim a As String For Each cCont In Me.Controls If TypeName(cCont) = "Label" Then a = cCont.Caption End If b = Application.WorksheetFunction.VLookup(a, Sheet1.Range("C4:I24"), 7...
  10. C

    Trying to find a way to use VLOOKUP and Replace

    I have a vary large data sheet that I've been working on for a long time. I've made a handy table that uses vlookup to mine the data and return various information from the different columns. I also have it set up so that if a cell is empty it just shows a blank cell. I've been looking around...
  11. B

    Vba code to find value in excel dataset

    I have a (x,y) table of data in excel that I am trying to find a corresponding z value for. Here is an example of the dataset in excel: <table x:str="" style="border-collapse: collapse; width: 528pt;" border="0" cellpadding="0" cellspacing="0" width="704"><col style="width: 48pt;" span="11"...
  12. D

    vlookup two values and return another one

    Hi All, First time posting here and im not that familiar with VBA. I have two workbooks which are data dumps from another program. Say I have WO #, Task #, and Cost in workbook1 and WO #, Task # in workbook2. I need to compare the WO# in workbook2 with WO# in workbook1 if it matches I need...
  13. S

    Vlookup, but with changing fileanames...

    In a excel file, I like to have a copy of a value that is always in cell A1, but everytime in a different excel file. I would like to have a formula that can coop with the (changing) filename, something like vlookup(). Can somebody help? Thx
  14. O

    Selection change and vlookup

    Hello All, I am really new to VBA and need your help. I am trying to use SelectionChange to click on a cell and then use vlookup to show contents of an adjacent cell - to do this I made a reference to the selection address in the worksheet that then runs the vlookup from the worksheet--the...
  15. W

    VBA-Worksheet Function

    Hi, I'm having trouble with the one part of my code I'm trying to basically do a Vlookup in a VBA Function, but I can't seem to get it right as I get the #VALUE! Error. Any guidance would be appreciated. Thanks! Public Function NetCostEE(FAverageCost As Variant) ' Define the data...
  16. garden_rael

    Vlookup driving me nuts

    HELLO GUYS... THERE IS SOMETHING SO SIMPLE SO SIMPLE THAT IS DRIVING ME CRAZY... Ler's see If I can explain my-self... I'm trying to create a summary for a report that runs almost daily... the summary should go into each created book and look for specific data for an specific user... I...

Some videos you may like

This Week's Hot Topics

Top