# Vlookup A Column To Return Multiple Values

Jul 6, 2007

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

## Vlookup To Return Multiple Values

Jul 6, 2007

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

## VLOOKUP To Return Multiple Values?

Jun 27, 2014

I 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"

## Vlookup And Return Multiple Values?

Jul 22, 2014

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

## Use A VLookup To Return Multiple Values

Apr 7, 2009

I 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.

## VLOOKUP To Return Multiple Values

Jun 3, 2008

I'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.

## VLookup Return Multiple Values?

Dec 19, 2011

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

## VLOOKUP Multiple Return Values

Apr 8, 2008

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

## Vlookup Formula To Return Multiple Values?

Jun 23, 2014

I'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.

## Vlookup To Return Multiple Values For Graphing

Mar 7, 2014

I 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.

## Vlookup Return Multiple Values In One Cell

Feb 15, 2010

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.

## VLookup One Value And Return Multiple Corresponding Values In One Cell?

Feb 23, 2012

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

## VLookup To Return Multiple Values In Same Cell?

Jul 17, 2012

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]....

## VLookup Multiple Values And Return Only Smallest Value Found

Nov 27, 2013

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]....

## VLookup Multiple Values And Return In One Cell With Comma Separated

Apr 6, 2013

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

## VLookup Return Multiple Hits From Same Column Of Data

Jul 14, 2009

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

## Concatenate Multiple Vlookup Results With Dash Exclude Null Values Or 0 Return?

Jun 10, 2014

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.

## 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.

## Ho To Get Multiple Column Values In One Shot Thru Vlookup

May 30, 2007

My 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.

## Return Values From Multiple Column If Exist

Sep 20, 2013

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?

## Match Multiple Values With Multiple Values From Another Table - Return Single Value

May 12, 2014

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‎

## VLookup To Return Yes And No Values

Aug 5, 2009

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.

## VLookup Won't Return Any Values

Jul 25, 2012

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?

## Vlookup & Return All Values 2

Jul 7, 2009

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.

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 ............................

## Vlookup Two Values And Return Another One

Oct 16, 2009

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.

## VLOOKUP Not Return Repeated VALUES

Jun 27, 2012

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".?

## Multiple Return Vlookup

Jan 9, 2007

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?

## Reverse Vlookup (get Value From Reference One Column And Return Value By Corresponding Row From Another Column)

Feb 8, 2010

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.

## VLOOKUP And SUM Formulas: Pick Up Another Value In Column 9 And Should Add Value In Column 7 And 9 And Return It

Apr 6, 2007

=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.

## Macro For Multiple Lookup Values And Return Multiple Values

May 9, 2013

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.