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
    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
    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
    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
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    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