vlookups

This is just an odd occurrence, and I was wondering if anyone can explain this to me. i was working on a formatted excel document for work. The document has a number of auto-populated fields, pulled from excel files on my company's network drives. I am not dealing with what I would call even...

Hi All, I am trying to use the Vlookup function to search for product costs from a list to match a sales order date. My downloaded sales data show the sales order delivery date , column "C" and I am trying to match the production costs with the correct date range , columns "N" and "O". The cells...

Hi! Needless to say how grateful i am to you for replying to my questions 6 months ago. Could you give your lights again? Assuming that i want to count how many times an individual says ''thanks'' :) to his colleagues. So, we have the table below: <tbody> From To A B C A D A C A...

Hi, First time poster here hoping someone can help. I have a set of scenarios (about 500) each with 10 variables that all feed a financial model on another tab - currently with a vlookup. I would like to create a macro or use another function to return the output of the model (it happens to be...

My apologies if there is something already out there on this but I can't find anything that answers my issue. I have 2 worksheets. One is a table of data and the other is (will be if i can get this to work!) a sumamry of dashboard of that data. Here's what I want to do: In my dashboard...

Hello again! I m trying to solve it, but ... I have a table with 4 columns and 22 rows: <tbody> From To Statement1 Statement2 0 0.19 3-5 0 0.20 0.30 4 3 .... .... ... .... 4 5 1 6 </tbody> I would like an if (vlookup maybe) statement as below If D1 ( a cell outside this table...

Hi, I hope someone can help me with the best solution for this. I have a tab that contains thousands of different records, both rows and columns. I want to create a summary sheet that only gives me certain columns and based on 2 lookup values. The user would change these 2 values to suit...

I am in need of a macro to help me with a very repetitive task. Each month I prepare a monthly summary in which 2013 data is compared 2012 data. Using a summary file provided to me, it lists monthly data and a yearly total for different clients (13 rows x 3 columns for each client). The issue I...

<tbody> <tbody> Skincare 1500 7 Magazine 120 Cosmo 345 SkinCare Magz 123 HairCare 2300 Hairstylist Mag 124 HairCare Mag 234 Shampoo Guide 453 7 Magazine 340 </tbody> My Questions is if I want to look up the value for 7 magazine, how do I do it? I...

Hello, I was searching for a solution to my question; however, I'm not experienced with the Match or Indirect formulas in excel and i'm not quite sure how to write the formula. Below is what I am trying to do: 1) I have two sheets, Sheet 1 and Sheet 2 2) cells in sheet 1 will pull values from...

I'm doing vLookups from one file to another, and would like to bring in the formatting of the cell in addition to the value. Is this possible in Excel 2003? If so - can you give me the formula to use? Thank you!

All I want to do is what I believe is a lookup that if an item in column A2 matches an item in Column A (on another worksheet) then copy the contents of column E(on the other worksheet) into column J2 (which is where I would be entering the lookup)...does that make sense Big thanks to whoever...

Hi, I know this question has probably been posted 100 times before but here it is again. I have a tab called Lookups which contains the following table: <TABLE style="WIDTH: 154pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=205 border=0><COLGROUP><COL style="WIDTH: 94pt...

I need some assistance please. I am running a vlookup function that returns text to a specified cell if the value my vlookup is referencing appears. I have several vlookups in column "A" of worksheet 1 that reference data in column "A" of worksheet 2. In worksheet 1, there is always a list of...

****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 12">****** name="Originator" content="Microsoft Word 12"><link rel="File-List"...

Hi, I have a simple vlookup formula which links to another file. If I close the file and go back into it, instead of showing the path to the external file as... Vlookup(A1,'M:\ABC\XYZ\example.xls It shows.... 'Vlookup(A1,'\\serverdetail\severdetail\ABC\XYZ\example.xls. When I try to...

Hi All, I have a spreadsheet where I'm using vlookup to calculate the cost of a product for a fundraiser at my sons school. Right now I'm using chained vlookups like this...

Example... I have a LIST of employees with the dates they were sick, on vacation or had jury duty... I would like to display the information in the OUTPUT FORMAT below with the Description populated by employee, by date. I have over 30,000 accounts I need to do this with 100 dates. LIST...

Dear Fellow Excel Geeks: The totality of the problem is: We have our own in-house database of customers (about 20,000). These customers are assigned to specific Sales people. We also buy in new databases and allocate these leads to Sales people. Before we can allocate them, we need to...

Good day excel brothers, seniors & juniors :biggrin: let's get str8 to the point. My data sheet comprises of projects in MW. So I have the name of a project and there power in MW. I would like to fetch all projects that have a similar MW power within a range of + and - 100, and align them one...