lookup multiple values

Hello all. I don't have very much experience with Excel but I am really trying to do my best. I am working on a small project and thought that Excel would fit the bill. I have run into a little snag (brain freeze). Here are some details. A friend, who has a small courier company, has asked me...

I found the following awesome script on digital-help.com that allows me to lookup and return multiple values concatenated into one cell (which I need to do): Function Lookup_concat(Search_string As String, _ Search_in_col As Range, Return_val_col As Range) Dim i As Long Dim result As String...

Hi, I am trying to create a formula that will allow me to look up three numbers in a row and if those numbers match the value in the row, then return a fixed value. Values that need to be looked up: 1, 3, 5 Row 1: containing numbers from 1 to 10 Value in Row 2 (in same column), if any...

Hi - I have a sheet with a column containing a Group name and another column with multiple group member ids in each cell separated with % symbol. For eg: A1 = Group A B1 = 34543%456456%23475 I have another sheet that has group member ids, however they are not of the same order as sheet 1...

Hi, I know how to return multiple corresponding values from a list based on one value, however now I am trying to return all the corresponding values from a list based on multiple values. My original code is as follows: =INDEX('FIC Info'!$A$1:$P$512,SMALL(IF('FIC...

someone please put me out of my misery. i have finally broken down after 5 hours of struggle and decided to ask for help. this is the situation. sheet 1 <tbody> Case date name product price A 10-oct john mobile 1000 B 15-oct mark tv 1500 </tbody> sheet 2 <tbody> case date name...

I'm not sure if Excel or Access is the best tool. I am seeking to search for roughly 1,000 unique search strings amongst 100,000 customers and identify all string matches. The customer data set consists of customer ID (column A) and customer name (column B). I would like to return all...

In deperate need of some help here.. I have a worksheet with data set out as follows (the slimmed down version and rates just jotted in): RefCcy SecCcy FX Rate GBP GBP 1.0 EUR EUR 1.0 GBP EUR 0.8 EUR GBP 1.4 EUR USD...