vlookup; match

  1. J

    vlookup formula in vba marco

    I want to make a macro based on vlookup formula from excel sheet. this formula is looking at k columns and go DataD sheet to get a value. =VLOOKUP(K6,'DataD'!D:G,4,0) I have something like this but it does not work... DataD.Range("D:G,4,0") = Vlookup() does anyone have solution for this?
  2. C

    vlookup and match with multiple column headers

    Hi Everyone, I am having trouble figuring out a vlookup problem. The sheet I use for work on a daily basis has repeating metrics across the sheet under different headers. For example, let's say there are only two metrics and they are "total $" and "total %". Those will be repeating twice with a...
  3. M

    Vlookup question

    In the folowing table my profesor used the following formula to get the cost of any number of ads <table style="border-collapse: collapse; width: 389pt;" width="518" border="0" cellpadding="0" cellspacing="0"><col style="width: 48pt;" width="64"> <col style="width: 59pt;" width="79"> <col...
  4. F

    How to populate a cell based on 3 inputs (variables)

    Business Situation: 1. for key tasks, I want to assign a role (analyst or a manager), responsibility (oversight or consulting) and indicate the amount of effort needed to complete that task (small, medium or large). Based on these 3 inputs, I want to populate a new cell within that row that...
  5. 1

    VLOOKUP Getting rid of #NA

    I'm using VLOOKUP to grab data and fill fields in a column. There are two conditions I want to prevent. The first is when the lookup doesn't find a match. It currently returns a #NA. I want it to just leave the field alone. The second is when it finds a match but there is already data in...
  6. K

    searching/displaying data with vlookup/index/match

    Forgive me if this has been asked and answered before, but I have searched and not seen this particular problem. I have a table of part and purchase order data - column A is part numbers and columns B-E are purchase order numbers. Elsewhere I want to do a lookup that, for a given part...
  7. G

    VLOOKUP for Text in unknown location on table

    I needed to return a specific column from a named table. I didn't know which column contained the information. I did, however, know the text string values of the column headers (ie. name | address | phone#, etc...). To complicate things the named table had 3 different "innertables" containing...
  8. C

    vlookup help lookup and match

    I need help with an inventory spreadsheet. We have thousands of products and I am looking for it to look at the inventory number and if it matches it should place a value in the threshold column for each inventory number. Example 1st spreadsheet item inventory number threshold dogs...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    • Replies: 49
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    • Replies: 40
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    • Replies: 35
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    • Replies: 35
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    • Replies: 30
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    • Replies: 25
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top