vlookup; match

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?

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

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

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

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

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

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

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