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...
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...
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...
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"...
I have my data arranged in a table which appears to be like this:
File ID QA
I wants multiple results here from lookup where I need all QA names for a give File ID. When I am trying...
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
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.
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...
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>
I’m a geologist and am trying to create an automated monthly reporting system for drilling information. I have simplified the tables...
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...