Vlookup Multiple Rows With The Same Lookup Value.

Dec 3, 2009

I'm trying to get a result of all rows in a table that has the same lookup value.

For example:


I want to look for David and that the result will be all rows that starts with David:

David 25
David 68
David 902

I tried using vlookup but it always returns the first row.

View 3 Replies


Multiple Lookup Values Rows And Columns To Lookup Single Target Column On Right End?

Apr 7, 2014

I have a table of data (say Column1 to Column 5) with multiple rows.

Column 1 to 4 will have the lookup values in multiple rows and Column 5 data should be picked up using vlookup or other lookup function.

I managed to somehow bring all these lookup values in (Column 1 to 4) in a single column in another sheet. I am now trying to use some lookup or other functions to match this single column and pick column 5 data in original sheet. Result i am expecting is lookup value in first column and next to it column 5 value.

It is basically a lookup wherein lookup value is spread over multiple rows and columns and result column is fixed. I tried using vlookup, but lookup value column and column number had to change every time when i moved from column1 to 4.

View 3 Replies View Related

VLookup - Single Value Lookup Returning Multiple Records Into Multiple Columns

Feb 7, 2014

Certification and Training tracking.xlsx

I want to create a certification only list on a separate tab of training that has been completed where a certification has been issued (as indicated by a "Y" in the "Certification?" column on the training tracking tab) and then populate from some of the fields vs. all of the fields.

What I have now, only pulls the first occurence, not all occurences. I saw that I could have identified the multiple columns that needed to be populated, but it didn't work either, so I'm fine putting a separate vlookup in each column.

View 6 Replies View Related

Multiple Ccolums/rows To Get Data From Multiple Columns/rows (vlookup)

Jan 15, 2010

I have created a spreadsheet to show some reports and I wanted to serch for some datas which overloops themeselves. If you can have a look at a test file I attached you will see the full picture. I have 2 tables, where the 2nd one is on the right side of the 1st one. 1st table:..............

View 3 Replies View Related

VLOOKUP Multiple Occurrence For Same Lookup Value?

Feb 14, 2014

accomplish VLOOKUP for multiple instances of a same Lookup value

First let me explain about my file:-


1.B2:B19 I have list of items which required to build a product

2.D2:D19 I have list of shortages against each item

3.C2:C19 I have list of dates when each item shortage will get fulfilled


1.C22:C31 I have picked the largest 10 different dates from Table1 by using LARGE formula.

Against each date which is update C22:C31, respective shortage qty has to get VLOOKUPED.

When there is a same lookup value, it has to keep pick next value (Shortage Qty) for same date.

View 2 Replies View Related

Vlookup- Multiple Conditions For Lookup Value

Jan 8, 2009

MetricsCategoryJan 2008VisitsTravel50view_offerTravel10

Above is the data I want to lookup on. I need to be able to do a lookup for travel visits and a seperate lookup for travel view_offers.

Is there someway to do this with a vlookup or maybe match index?

View 9 Replies View Related

Vlookup Table To Lookup Data In Columns And Rows

Apr 28, 2007

I have a lookup table which needs to be able to retrieve data from columns as well as rows and not sure if this is possible.

My data is set up with an ID number, financial year and data across the columns e.g

ID F/Y Apples Pears
9999 2004/5 5 4
9999 2005/6 7 8
9881 2003/4 5 3

My lookup table will have the ID number field which will be manually entered to lookup the information on the data sheet. e.g

ID 9999
FY Apples Pears
2004/5 5 4
2005/6 7 8

I can't work out a way to get excel to only give me the number of apples and pears for that year for that ID number. Not all ID numbers will have the same number of financial years so I may need to use VBA.

View 7 Replies View Related

VLOOKUP To Return Multiple Cells Of Same Lookup Value

Dec 1, 2009

I am trying to create an automated receipt for a list of artists. I have given the artist an individual reference so I am doing a VLOOKUP to return description/price value etc but I can only get it to return the initial value and I have approx 10-15 works under each reference. Maybe VLOOKUP is the wrong formula to use.. I have attached the file.

View 5 Replies View Related

Using VLOOKUP To Retrieve Multiple Data For The Lookup Value

Jan 8, 2010

I have to write some VLOOKUP formulas to pull several items from a report, the problem is there could be multiple items for each lookup value as the example below:

Company Data ABC Monday ABC Friday ABC Thursday DEF Friday GHI Monday
I need to reference every piece of data for every company but using the VLOOKUP formula, I am obviously only able to get the first instance of the lookup value (company ABC)

How to I write the formula to lookup the other data? The practical appliation I am using this for has anywhere from 300 to 400 lookup values.

View 9 Replies View Related

Lookup With Multiple Rows.

Sep 22, 2009

I have been trying to auto update a table by looking up information from a table on top. However, for the top table there are multiple entries in the same column, and my look up only checks the first row and ignores the rest.

My formula at this point is: =IF(ISERROR(INDEX($C$3:$H$33, MATCH("X", I$3:I$33, FALSE), 4))=TRUE, "", IF(INDEX($C$3:$H$33, MATCH("X", I$3:I$33, FALSE), 4)=0, "", INDEX($C$3:$H$33, MATCH("X", I$3:I$33, FALSE), 4))).

If you can take a look at my attachment, this formula is in the cells I40:W40. Eventually, I will want to populate the entire bottom table with the same formula.

View 2 Replies View Related

Possible Multiple Rows LOOKUP

Jan 10, 2008

I have a worksheet which Sorted in ColA contains Product Id#, ColB contains Vendor, ColC contains Grade# (1 thru 6). Now there may be multiple Vendors (ColB) for same Product # (ColA) but with different Grade# ColC).

I would hope if you can please help me formulate for ColD to pull (list) ALL Vendors for the same Product# (there maybe as many as 6) PROVIDING that the Grade# (ColC) is either 3 or 4.

View 9 Replies View Related

Reverse VLookup (Index Match) To Return Multiple Values Based On Single Lookup Criteria

Jul 11, 2012

I have encountered a situation where I need to essentially accomplish a reverse Vlookup (using index match) and return multiple values.

View 1 Replies View Related

Lookup Returning Multiple Columns And Rows?

Oct 8, 2013

I'm working on a database right now for our school, similar to a directory. What I want to do is be able to look up what items a staff member has been issued and when/if they were returned. What I have right now is one sheet with all the information about the staff that looks like the one below. I want to create a separate sheet where you could look up a staff member by last name and can find all the information in the array relative the the specific cell looked up.

Last Name
First Name

So, on the "lookup" sheet, I want to be able to input either Doe and have the look up return cells B2:E6, or if I input Smith it should return cells B7:D11.

I've been experimenting with Vlookup, hlookup, index, and match but haven't been able to get exactly what I want..

View 8 Replies View Related

Vlookup - Multiple Rows To One

Feb 5, 2009

Just learned a little about vlookup and wondering if it can be use to solve the following. I have attached "worksheet1" that shows what I'm trying to do. The "detail" sheet is downloaded from another software package. There may be one to five rows of Product #'s with their component # and percentage on the same row. I would like (on a new sheet) put one Product # and all the corresponding component #'s and percentage's on the same row. (An example of how I would like it to be is on the "one row" sheet.)

View 3 Replies View Related

Using Vlookup On Multiple Rows

Oct 13, 2009

i am trying to create an interactive calendar that displays what is happening on different dates depending on the activity. i.e. if 'workshops' is selected then it will show all the workshops happening in the month. the problem is that i have created a new line for each workshop in my table array and want it to display all the returns in a single cell on the calendar. I am using a vlookup and have used a unique reference so that it picks up multiple rows, but it will still only return one value.

is this possible or do i need to collate all the data into one cell? I have attached the spreadsheet as i am sure the above prob does not make sense.

View 2 Replies View Related

Using Lookup Function To Combine Text From Multiple Rows

Oct 4, 2012

At a high level, I have several thousand rows of data. For the sake of simplicity, assume there are two columns: 1) Name; and 2)A comment (optional, could be blank). See below for example..

Sheet 1
Row 1: Mike │ "Great to work with"
Row 2: Mike │ "Bad manager"
Row 3: Tom │ "Great guy"
Row 4: Mike │ (blank)
Row 5: John │ "Cool"
Row 6: Mike │ "Best boss"

On a separate sheet, I want to be able to somehow use a lookup function to combine all the comments for each name in a nicely formatted package (notice how I skipped the blank space so it wouldn't take up a line.

Sheet 2

="Comments for "&[ref to cell containing "Mike" in another sheet]
- Great to work with
- Bad manager
- Best boss

View 6 Replies View Related

VLookup Return Multiple Rows

Apr 6, 2014

I am designing a workout template i have a table with sets and reps and i would like to be able to select a heading and return all of these values to a specified box.

I have attached the file : excel help forum.xlsx

View 2 Replies View Related

Lookup A Value Based On An Array Spanning Multiple Rows And Columns

Nov 24, 2008

I'm having difficulty finding a way to ask excel to lookup a value based on an array spanning multiple rows and columns. There's a mock example in the attached.

View 2 Replies View Related

Fastest Lookup Method: Use A Key To Lookup A Value (VLookup, Index/Match, DGet, And The Rest)

Mar 26, 2008

Excel offers many ways to use a key to lookup a value (VLookup, Index/Match, DGet, and the rest). What's the fastest way to perform a lookup of a small table of, say, 30 rows of key-value pairs? Theoretically, it would be most efficient to use a branch table (also known as a jump table). See the wikipedia article for branch tables: http://en.wikipedia.org/wiki/Branch_table. Does Excel/VBA have a way to create a branch table for such lookups?

View 9 Replies View Related

Using VLookup To Lookup Date Within Multiple Date Ranges

Jan 5, 2012

I have a table with three columns. I'm building a calendar on a separate worksheet and am looking up the "value" based on a calendar date. So if a date falls within any of the ranges, I'd like to return the value in column C. For example, if the date is 02/07/12, I'd like for the result to be value 1, or if the date is 04/17/12, then I would like the result to be value 3. I've used a nested vlookup, but all that give me is the value when either the start or end dates match, but I can't get a value when the date falls within the range. If the dates were consecutive, I would simply use vlookup/TRUE, but the dates are not consecutive.

ABC102/06/1202/09/12value 1203/12/1203/15/12value 2304/16/1204/19/12value 3405/21/1205/24/12value 4506/25/1206/28/12value 5606/25/1206/28/12value 6

View 4 Replies View Related

Lookup Vs Vlookup

May 30, 2009

i am using Vlookup in all My files and the 4Th argument i put it 0 to give exazct result

My Question
Lookup Function give the Exact or approximate match and as i know Vlookup give the first result but Lookup give the last result

View 9 Replies View Related

Two Lookup Values, Vlookup

Apr 5, 2007

I want to match two different values in the same row and then have it return another value in that row.

View 9 Replies View Related

Vlookup: Lookup The Title

Jan 29, 2009

I have a tab with the following on:


I then have another tab which is similiar to this:

Australia Danny 23
Australia David 25
Canada Ben 35

Basically what I want is....where ive put some formula I want to lookup the title, in this case australia which is the cell above, search within the table then enter the name to the right of that. I have done this, however it only ever uses the first name on the list..... Example i always get danny on a role, i have managed then to get it to say david underneath but then if i copy the forumla down again it continues with danny, david etc.

View 4 Replies View Related

Vlookup Using Two Lookup Values

Nov 21, 2005

Is there a way to perform a vlookup with two lookup values?

I'd like to look up the value of A1 and B1 in a table with A1 and B1 values
included to return cell C2 from the table. I've had limited
succcess using concatenate and then using vlookup on that cell but i'd like
to not have to do the concatenate step.

View 10 Replies View Related

VLOOKUP() Style But 3 Value Lookup

Mar 4, 2009

I have a table that has, amongst many columns, a year, month and a name column.

I want to do a formula that takes in 3 values (name, year, month) and returns a sum of values found in a variety of other columnswhere these 3 values are matched.

I would know how to do this in SQL but wonder if Excel can do this type of thing on one large data table?

View 9 Replies View Related

How To Specify More Than 1 Lookup Range With VLOOKUP

Sep 4, 2012

Is there a way that I can do a vlookup in 1 file and specify more than 1 data range to lookup the data in?

In this case I have one file to put the vlookup in and a second file with more than 1 tab and I want to have it search each of those tabs and return the result. The format of these sepatate tabs are to each other and for that matter, identicle to the main file.

View 1 Replies View Related

VLOOKUP With The Lookup Value On A Different Sheet

Apr 7, 2009

Formula is on Sheet1 and table array is on Sheet1
but the lookup value is on Sheet2 in Cell B15

Below does not work, either does anything I have tried.


View 9 Replies View Related

Lookup Second Occurrence With Vlookup

Dec 29, 2006

I am using vlookup to find the ORIGIN data and DESTINATION data but the subheading is the same for both- see below(site name, city...). How do I find the second occurrence for the same heading?

Is there another command that would be better?

col A col B
Line#1 CITY

Line#1 CITY

View 5 Replies View Related

Vlookup With Two Lookup Values

Apr 11, 2007

=VLOOKUP(C29,'Zero Days YTD'!B:Q,16,FALSE) is my current formula where C29 = Jack Bates.
As of this month Jack Bates is now in two places on worksheet Zero Days YTD. One is named "Jack Bates (from AMU 3/1/07)" and the other named "Jack Bates (to APU 3/1/07)"

I tried =VLOOKUP("Jack Bates (from AMU 3/1/07)"&"Jack Bates (to APU 3/1/07)",'Zero Days YTD'!B:Q,16,FALSE), but that didn't work.

View 3 Replies View Related

VLOOKUP In VBA Where Lookup Range Is From The Sheet To Right

May 16, 2014

I am writing the code for a VLOOKUP in VBA..I was using the .Formula = "=VLOOKUP(LookupValue, LookupRange , Column No, 0 )"

But, the problem is that the LookupRange is to be done from different sheets everyday as the name of this sheet is going to be like 16th May,17th May etc.

The common thing is that this sheet is the adjacent sheet next to the one in which we are trying to get the VLOOKUP work...so what solution can i use.

View 12 Replies View Related

Copyrights 2005-15 www.BigResource.com, All rights reserved