multiple values

I hope someone can help me with this, seemingly simple(?), need: I need a formula to search through a table's row for multiple instances of a certain lookup value, then retrieve an associated retrieval value from a different row in that table, and concatenate all those retrieval values into a...

Hi all, I am trying to find a way to calculate a value using parameters stored in different sheets/tables. I have been trying to do this with sum and vlookup without success. The input data looks like this: <tbody> Type Power A 5 A 9 B 0 B 1 C 6 C 2 C 3 D 7 D 0 D 0...

Hello and thank you whomever is taking time to read this post. I really appreciate it. :) I have been tasked with helping my boss get a comprehensive excel doc together that saves a lot of time. In doing this, I have made enormous progress, but i've hit a snag. In a perfect world, I want to...

Hello, I have a workbook with multiple sheets. In the first sheet there are (among others) some values (~500) which I need to search if they exist and where in the other sheets. In a few words I need the "Find" function for multiple values.

How to return multiple values in vba? What to use index or any other function

Hello, So I am a Newbie to this forum and have read several of the post but have not been able to find the answer to my issue. I am trying to create an IF/AND formula to score a students' assessment Student is assessed in three fields and received one score for each field. Final score is a...

Hi, Not sure if this can be done (either via formulas or a macro). Please see example by clicking the link below. Thanks for any help that anyone may be able to provide! https://www.dropbox.com/s/1axlgrn7w9xnpep/Look%20up%20Returning%20Multiple%20Values%2020160331.xlsx?dl=0

Hi, I am really struggling with a way round this, will try to explain as simply as possible: - I want to find the monthly revenue generated by different contracts for my company. Each contract has a reference number (this is the unique ID/lookup). - Since monthly revenue reports are not...

I have this formula and it works great. But now I find that I need a 2nd criteria to keep from getting duplicate rows. I need for 'Raw NimSoft'!F:F="*Client" in addition to the 'Raw NimSoft'!D:D="QOS_VMWARE_DATASTORE_CAPACITY_GB" already in the formula. Here is my working formula. It simply...

Hello there, So I have: column A where a value can be repeated unlimited times column B can vary between X or Y Column C is where the formula needs to go: If value in column A contains an "X" in column B, in any of the rows where it appears, then "OK" I'd really appreciate your help...

Hello, I have figured out how to compare and search two columns to return a corresponding value, but there are multiple values that may match, and I am unable to collect the multiple values. The headings I am searching are below: Full Name (this is the column I am searching - Column A)...

Hi All, I'm looking for some guidance on a lookup question that I just can't seem to find a solution for. I originally posted this to a thread called 'Return multiple corresponding values using multiple lookup values' but I was not able to get what I needed from it so I've reposted a new thread...

Hello everyone. I have an issue I really can't get my head around. I have a Sheet called "Crediteuren" with all creditors of my company, containing the following information: Col A: Name creditor Col B: Number creditor Col C: Category Col D: Contact person Col E: E mail address Col F...

Hi, I am doing a price comparison and want to add a field for average price. However not all fields are populated on every row so cannot simply add up and divide by total. Therefore I am trying to do a countif to show only populated cells. I cannot use simply countif >0 as I have another cell...

I'm working on a spreadsheet and I want to return a specific value based on different variables. In column D the user can select from two different values (Simp or Audit), then in column H they can select one of 3 values (Val1, Val2 or Val3). Based on what is selected in these 2 columns I want...

So my excel have tens of thousands of rows and some of them contain the same information. For example, there are part numbers that we get from multiple suppliers so I would like to use a code to find the multiple suppliers(if a part number has one). Here is my code ( actually I got this online...

Hi guys, I can't find a code that suits my needs, so I come to ask for your help. The basic idea I want to achieve is to have unique data in my sheet, but it's a bit more complicated then a basic RemoveDuplicates. There are some if's and but's I will try to explain as clear as I can. Col. A...

Hello all! Any ideas how to modificate below code to search using two criterias, first as it is from CSV column, and second single value from another? Function SplitLookup(myTxt As String, myTable As Range, myColumn As Integer) As String arrValues = Split(myTxt, ",") For Each Item In arrValues...

Hello, I'm sorry if this question has been asked already but I've been looking for an answer for a while to no avail. I would like to know how to lookup multiple values using multiple criteria. Let us say that in column A are last names, in column B are first names, and in column C are phone...

I have data that shows me what day and what DC a driver works out of. This issue is, the driver may have driven multiple times for the week and will show up in the data in multiple rows. I would like to use a formula so I can put it all in one row. All the INDEX, MATCH, SMALL formulas I have...