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.
View 5 Replies
ADVERTISEMENT
Jul 6, 2007
Is there a way where i can vlookup a column and return all matches if there are multiple values?
View 5 Replies
View Related
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"
View 3 Replies
View Related
Jul 22, 2014
formula to vlookup and return multiple value in a single as per the attachment.
View 7 Replies
View Related
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.
View 3 Replies
View Related
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.
View 14 Replies
View Related
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
View 3 Replies
View Related
Apr 8, 2008
I am up for any way that this would be possible ....
View 17 Replies
View Related
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.
View 1 Replies
View Related
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.
View 7 Replies
View Related
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
View 9 Replies
View Related
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]....
View 6 Replies
View Related
Jul 6, 2007
Is there a way where i can vlookup a column and return all matches if there are multiple values?
View 3 Replies
View Related
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]....
View 4 Replies
View Related
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
View 7 Replies
View Related
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.
View 6 Replies
View Related
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
Nov 25, 2009
I've got a complicated logic formula which looks at multiple values on a large spreadsheet to return a singular figure based on whether all these conditions are met. It works well but I wan't to add an extra stipulation to it. I won't paste the full formula as it probably wont mean much without all the data so heres a mini version with simplifed conditions - but that DOESNT work:
=SUMIF(K10:K13,IF(H10="CAT","CAT",IF(H10="DOG","DOG",IF(H10="ALL",OR("CAT","DOG"),""))),L10:L13)
Its the last bit that I'm having problems with - I want to say if H10 equals "ALL" then in my table of values to add up not just "DOG" values or "CAT" values but "DOG" and "CAT" values
View 9 Replies
View Related
Mar 24, 2014
Column A:
pants A green
Pants B red
Jacket C green
Jacket D blue
Polo C white
....
I need a formula to find some value( in our case "colors" = "green, red, blue, white" ... = 20-30 values), and to return in column B, the values, like:
Column A: Column B:
pants A green | green
Pants B red | red
Modern green Jacket | green
blue winter jacket | blue
Polo white D | white
I have different product feeds (csv) and i will like to search for colors in the product names.
View 2 Replies
View Related
Nov 7, 2008
I am trying to find a way to use information in one cell in order to look up corresponding multiple values on another sheet. The problem that I am running into is that VLOOKUP only returns the first value. I need the values to be calculated in different cells going vertically, not all combined in the same cell as was in an earlier post. I am not looking to sum anything so a pivot table also doesnt work.
Sample data:
A / B / C / D
Identifier / Pub ID / Invoice # / Job #
ABCD1234 / ABCD / 1234 / A41254
ABCD1234 / ABCD / 1234 / B41254
ABCD1234 / ABCD / 1234 / C41254
DCBA4321 / DCBA / 4321 / A56789
etc.
I am looking for it to do this:
A / B
Identifier / Job #
ABCD1234 / A41254
/ B41254
ETC.
I want to enter ABCD1234 into another worksheet and have it return all of the job #'s, but I have a lot of these so I don't want to have to look up how many job numbers there are associated with it and have to enter different formulas into multiple cells. Filtering also isn't an option as there are simply too many cells to calculate.
View 11 Replies
View Related
Dec 19, 2013
I can manage an array formula that returns a value based on a criteria. Simple. But I want to add in an additional couple of criteria. Now I'm stuck....
My sheet looks at a manually entered postcode, finds out what region this is in, and returns a list of postcode I have defined as being in that region. (So the postcode WF1 3JY would return a region of Yorkshire, and list postcodes of WF, BD, L, etc)
I also have a list of engineers, with a column for their home postcode.I want to be able to list all the engineers from my list whose home postcode matches any of the values on the already created list from the postcode and region entered. So far I have this, which finds me all the engineers for just one postcode area.
View 4 Replies
View Related
Aug 25, 2006
I would like to be able to use the Vlookup function to return more then one value as a result of the criteria. I have a cloumn of dates that populates the X axis of a gantt chart with data whilst the Y axis will be populated by a site reference resulting in a program of work, the Y axis data is the result of a vlookup function. My difficulty arises however with multiple sites, for instance where two or three sites will be visited on the same day. The vlookup function will only return the first value it finds in a range to the formulated cell. The result being a missing site(s) from the gantt chart / work program. is it possible to return all values to a cell i.e. site1, site2, site3. using a vlookup or do i need to use another method of doing this?
View 2 Replies
View Related
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
View 4 Replies
View Related
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.
View 9 Replies
View Related
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?
View 9 Replies
View Related
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.
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 ............................
View 9 Replies
View Related
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.
View 9 Replies
View Related
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".?
View 4 Replies
View Related
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?
View 9 Replies
View Related
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.
View 3 Replies
View Related
