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...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top