# Vlookup A Column To Return Multiple Values

Jul 6, 2007Is there a way where i can vlookup a column and return all matches if there are multiple values?

View 3 RepliesIs there a way where i can vlookup a column and return all matches if there are multiple values?

View 3 RepliesADVERTISEMENT

Is there a way where i can vlookup a column and return all matches if there are multiple values?

View 5 Replies View RelatedI have a list of countries in column A, there are duplicates in this list. In column B are numbers corresponding to the country.

A B

IRELAND 1221

GERMANY 2341

USA 3443

IRELAND 2231

Ireland could be in the list and have up to 20 different values beside it in column B

On a separate sheet i have a drop down list of all the countries. I am looking for a vlookup or something similar to return a list of all the numbers beside IRELAND when Ireland is selected in the drop down list.

I had been trying a vlookup but this looks at the list and stops at the first "IRELAND" it finds and just returns the value beside the first "IRELAND"

formula to vlookup and return multiple value in a single as per the attachment.

View 7 Replies View RelatedI have a workbook with 2 sheets. The sheet called 'data' contains all purchasers names (which do get repeated), the item they bought and 3 item costs, all in range A1:E15. The 'lookup' sheet allows the user to enter a purchasers name in cell B1, then I want all the items that purchaser bought listed with the corresponding item costs. I've attached a sample spreadsheet.

View 3 Replies View RelatedI'm having trouble getting my payroll data to combine. I've been using VLOOKUP to look up employees by their Personel Number (Column A) and return their name (column B), Cost Center (Column C), the Fund that they are paid from (Column D) and the Amount they are paid (Column E). The problem is that some employees are being paid out of 2 or more funds and VLOOKUP is only returning the fund that appears first, leaving out the other portion of their pay and thus making my grand total quite far off. How can I get Excel to return all the entries for a particular Personel Number? There are more than 16000 employees, so this is no small spreadsheet.

View 14 Replies View Related I've been trying to research vlookup to see how I can use it or something like it to return multiple value for a dynamic chart I'm trying to build. I've found several paged to give examples but I can not seem to figure it out with my sheet b/c the examples differ from mine I have a financial spreadsheet with several categories and I want to make a chart for all my utilities. i need a array formula (i think) that will search for (example) My salary, my wife's salary and other income and extract those values in the next column (Credit (+)) to build a chart... (i will use this same concept to make other charts as well.) The Categories column is F and the values will need to be extracted for the chart are in G. doesnt matter where they are extracted to but for the sake of being speific ill say starting P50.

(first row below headings is row 5)

CATEGORYCREDIT (+)DEBIT (-)Salary - Byron$ 2,571.11 Utility - Electric$ (154.25)Salary - Felicia$ 1,120.20 Utility - Gas $ (79.47)Mortgage$ (852.01)Salary - Byron$ 2,499.53 Other Income$ 150.00

I am up for any way that this would be possible ....

View 17 Replies View RelatedI'm trying to use vlookup to return multiple values for the same unique identifier. I've read a couple of examples within the forums, but I haven't been able to find anything I understand. I have employee ID's and these ID's have specific access associated with their ID's and each access is listed within a different row. Within a new spreadsheet I removed all duplicates of the employee ID so now I no longer have a one to one match between spreadsheets, so I would like to create a vlookup that will list all access associated with each employee ID. I have attached a sample of the data sheet I am working with.

View 5 Replies View RelatedI am attempting to graph data based on work down in specific work centers to track efficiency. I can download all items that were finished for a certain time frame (yesterday, last month, last year, etc.), but the data only shows up as the item, quantity, and the date of closure. I take that info and copy and paste it to the close out tab of the other work book, where it references another sheet to pull in the time required to complete the task, and the work center that did the work. My problem is when an item has multiple work centers on the same item and then taking that info into a pivot table to graph. This can be done manually, but I was hoping I could create a way to only have to copy and paste the data and have it return the work done.

I have included a shortened version of what I am trying to do, eventually there will be 25000+ items on the data tab, but if I can get this to work, then i assume I can extrapolate.

I tried searching for a solution to my formula problem in this forum regarding vlookup and saw similar formula e.i returning multiple values but it doesn't cater with what I need.

Vlook is returning only the first value but what I need is to return all the multiple return values in 1 cell. I've attached a sample worksheet for reference.

OK for example if i hae this list of data:

Invoice number Order number

111 560

112 561

112 562

113 563

What i need to do is a vlookup from the above table to return the following:

Invoice Number Order number

111 560

112 561, 562

113 563

Traditionally the vookup will return the first value it can match. I can return multiple values on different lines using an array formula but this is not useful.

In the example below I have table array A1:B8. Lookup criteria in cell A11 and want to return MULTIPLE values from column B in cell B11.

I would prefer to not use VBA if possible

A

B

1

[Code]....

I have an excel sheet with multiple columns. In one column I have X's and in another I have a limit. I need to look down the stuff column, find every X, match each X to its corresponding limit and then compare all the limits and return only the smallest limit found. I.e if I was looking down the stuff column I would find 4,6,8,8,3 and thus I would return 3 as my value. I am very new to working with excel formulas,

limit

something

stuff

4

x

[Code]....

code1

code2

lookup Range1

lookup Range2

Return Value

Lookup

Multiple Return

[Code]....

I am trying to vlookup multiple value and return multiple values in one cell

I am running a Vlookup on a large set of ID#'s that exist accross multiple servers.

The data is structured in (2) columns how you see below , and you will notice that the same ID# can show up on multiple servers.

However, the VLOOKUP is only returning the first match it finds.

Assuming that I want to keep the data structured as is, how do I make the vlookup return all matches?

ID# LOCATION

23 SERVER1

34 SERVER4

23 SERVER2

13 SERVER1

17 SERVER3

34 SERVER1

The 3 vlookup will be in a single cell for concatenation like :

=vlookup1&"-"&vlookup2&"-"&vlookup3

Problem the are 3 vlookups where it will return names (with format -> Fname, Given Name Middle) and probably blank returns.

I have problem with the replace since there are also spaces between the Fname,Gname and Mname sample name with spaces.

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 RelatedMy problem is how do i get multiple column values at one shot.

For example in one excel sheet i have columns A,B,C,D,E and in A column i have all the Partner ID's and rest of the columns i have the data.

Now in other excel file I have Partner ID's which are not in order...now i want the data in all 5 columns according to partner id's from the previous sheet i need to do a vlookup function for five times to get the same data....is there any way that we can do it in one shot.

I have a challenge which I am trying to solve without VBA and I am uncertain how to approach

If I have the following spreadsheet consisting of three columns:

FieldA, FieldB, FieldC

A........3................

B........5........6......

C.................7......

D.........................

E.........................

F........6........4......

The result I would like to achieve is

FieldA, FieldB, FieldC

A........3................

B........5........6......

C.................7......

F........6........4......

So, it means I would like to return the rows where Columns B and C have a value. Is this possible with strictly formulas?

I am trying to look & match key values from 2 areas of one table with two areas of another table; in turn, it'd return one value based on the lookup table...

Attached worksheet : Test booklet.xlsx

Is it possible to write a vlookup that will return a value of Yes if the value is true and a value of No if the value is false?

I have data in column A on sheet 1 so the lookup value starts in cell A2 and the table array is on sheet 2 in columns A and B so the column index is 2.

When I use my vlookup function and hit enter, the no value shows up and I can still see the function syntax that I wrote in the cell. Here's a sample of what my sheet looks like:

Number

Name

Hazard

Number 2

[Code]...

I need to know the value in the 'number 3' column is for the 'number' column. For example, I need '1302-76-7' inputted in a column adjacent to one of the first three columns. Another example: I need 'na - 07' inputted in the same row that has a 'number' of '1073'. This is how I want it to look:

Number

Name

Hazard

Number3

[Code]...

When I type in the vlookup formula listed above, nothing happens. This is exactly how it looks in my spreadsheet, even when I click another cell or hit enter. Is my syntax wrong or have I just missed something?

Very similar to the original thread 'vlookup & return all values', i need to lookup a velue and return all the relevant values.

Unlike the original thread, i need the macro to return an array of cells, rather than just one.

The macro from the original post was this

Public Function FindSeries(TRange As Range, MatchWith As String)

For Each cell In TRange

If cell.Value = MatchWith Then

x = x & cell.Offset(0, 1).Value & ", "

End If

Next cell

FindSeries = Left(x, (Len(x) - 2))

End Function ............................

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 to compare the Task # in workbook2 with the Task# in workbook1 (but it must compare the same row in which the WO # match was found) then it must return the cost from workbook1 to workbook2 ( again the cost must come from the same row in which the WO and Task match were found in).

This could be a VBA code or even a formula that does not matter.

I have a table like this. I tried using a formula to get the return code values equal no more have exito.

45

2

43

5

45

89

76

[code].....

How to do VLOOKUP bring the values of the numbers "1".?

Is there a way to get a vlookup for return multiple values if there are reoccuring numbers? for example

A 1

B 2

C 3

D 4

A 5

If those were my two columns, could I get the value A to return both 1 and 5?

I want to get value from reference one column and return value by corresponding row from another column. This can be done by vlookup column. But it find value from 1st column and return value from given relative column. That mean find from Left column and return value from right side given column number.

But I want find from Given column number and return value from given left column. For Further detail see the Attached file.

=IF(ISNUMBER(VLOOKUP($E8,Su!$D:$K,7,FALSE)),VLOOKUP($E8,Su!$D:$K,7,FALSE),)*$I8

In the first vlookup it picks up a value. I need to do the same vlookup function but it should also pick up another value in column 9 and should add value in column 7 and 9 and return it. Employee id numbers are in column E in the first page.My formula checks for the employee id in Su sheet and retrieves the value from the seventh column. I need to retrieve also from 9 th column and add them together.

I have attached sample sheet.

I need to populate the Rep Names looking up 3 Criteria (Client Id,Curr Cov Id,Dom Buy Grp Id) from the Table 1, either one matches the Rep Names has to populate.

The data has to be pasted on WIP_Sheet in different columns.

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