vlookup multiple values

Really hoping I can get some help with my issue. I have a bunch of Products in Column C of which many are duplicated. In Column D I have the locations of the IDs of which there can be two. I want to know when an ID is in both locations but vlookup and index match only shows me the first...

Help! I work for a college and I need to condense student grades. The first chart represents what my original data set typically looks like. Students can take 1 to 2 courses a semester and I would like to be able to condense multiple course grades to one row per student, so that my report...

Hi all, I have decided its time to become more efficient at my analytics and this will be my first of many questions! I have a data set where the B column consists of a bunch of merged cells These merged cells then have corresponding data for every seperate month in the C column, so 1 of the...

Dear all, https://docs.google.com/open?id=0B2kA5LQXm97jX2FBSU9odm9tNXM On the above spreadsheet I have two tabs. On the first tab I have 18 teaching assistant named and each assigned a colour (TA1, TA2 etc). In their relevant columns the code for the class and teacher they will be working...

Hi, So I know that with VLookup, if your Lookup Value occurs more than once in a column, it will only return the value of the first one found. Is there a way around that, or another formula I can use, without having to figure out loops and macros? Let me explain what I want to do: I have a...

Assume Product is Part A and Qty is 4 for the following fields. What is the formula I need to enter to return the correct price for the given quantity? (I expect the formula to output 25.87) Field values are as follows: A1:Product B1:Price C1:Qty Start D1: Qty End A2:PartA B2:10.35 C2:50 D2:500...

I have searched this forum and elsewhere and can't find the answer (and it seems like such a common thing--maybe I'm not looking for the right terms). I'm using Excel 2007. I get data in a worksheet each week, 1500 to 3500 work site records (rows), about 100 fields in each (columns). I'm using...

I use Excel 2003. Now I have a data sheet in my workbook like this: <TABLE style="WIDTH: 414pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=551 border=0 x:str><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 32pt; mso-width-source: userset; mso-width-alt: 1572"...

Hi Friends, I have my data arranged in a table which appears to be like this: File ID QA 3803 Vishnu 4006 Shalini 3803 Akanksha 5034 Sanchit 5034 Shalini 3803 ****iz I wants multiple results here from lookup where I need all QA names for a give File ID. When I am trying...

Hi I'm trying to do a Vlookup with a ref no. 91903 to 91903 this is the easy part for me but i have multiple ref no but the answers i'm looking for are different. in the place its looking up its set out like 91902 3rd 91903 1st 91903 nontime 91903 2nd 91903...

i have a file and in in column A I have data. I need to do a vlookup in "Tab1" to and if there is a value to return it. If the value is not there then check "Tab2" and bring back the value. Now the problem is that the value might be in both but I always want the "tab1" value before it goes to...

Good Morning all from the UK, I am trying to create a Vlookup to return the value from a cell that falls between the range of two others. For example cell value is 6 thich falls between 5 and 10 so returns 0, I dont want to list every number as this will make the spreadsheet to big...

Hello All! A newbie here. I appreciate any help. I am actually quite good in a # of areas - but not in VLookups. I basically have two tabs with similar lists of customers and misc info. One list has addresses and the other doesn't. Each customer has a customer # reflected on both tabbed page...

Hi, I’ve been trying this out for a while but am having no luck.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I’m a geologist and am trying to create an automated monthly reporting system for drilling information. I have simplified the tables...

Hi All, First time posting here and im not that familiar with VBA. I have two workbooks which are data dumps from another program. Say I have WO #, Task #, and Cost in workbook1 and WO #, Task # in workbook2. I need to compare the WO# in workbook2 with WO# in workbook1 if it matches I need...